7.2.18. Speed of
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
variable. See Section 7.5.2, “Tuning Server Parameters”.
To delete all rows from a table,
if faster than
Section 13.2.9, “