DBA > Job Interview Questions > MySQL and SQL

MySQL - Speed of DELETE Queries

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

MySQL - Speed of DELETE Queries

If you want to delete all rows in the table, you should use TRUNCATE TABLE table_name.
The time to delete a record is exactly proportional to the number of indexes. To delete records more quickly, you can increase the size of the index cache.

(Continued on next question...)

Other Job Interview Questions