Why 'delete from table' takes a long time when 'truncate table' takes 0 time?

sql mysql performance truncate
ripper234 picture ripper234 · Dec 24, 2008 · Viewed 10.9k times · Source

(I've tried this in MySql)

I believe they're semantically equivalent. Why not identify this trivial case and speed it up?

Answer

Otávio Décio picture Otávio Décio · Dec 24, 2008

truncate table cannot be rolled back, it is like dropping and recreating the table.

Related questions

MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET

What is main difference between INSERT INTO table VALUES .. and INSERT INTO table SET? Example: INSERT INTO table (a, b, c) VALUES (1,2,3) INSERT INTO table SET a=1, b=2, c=3 And what about performance of these two?

Read More
Best way to test if a row exists in a MySQL table

I'm trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this: SELECT COUNT(*) AS total FROM table1 WHERE ... and check to see if the total is non-zero or …

Read More
delete all from table

what's faster? DELETE FROM table_name; or DELETE FROM table_name where 1=1; why? does truncate table work in access?

Read More