7.2.18. Speed of DELETE Statements
The time required to delete individual rows is exactly
proportional to the number of indexes. To delete rows more
quickly, you can increase the size of the key cache by
increasing the key_buffer_size system
variable. See Section 7.5.2, “Tuning Server Parameters”.
To delete all rows from a table, TRUNCATE TABLE
tbl_name if faster than
than DELETE FROM
tbl_name. See
Section 13.2.9, “TRUNCATE Syntax”.
