:: DEVELOPER ZONE
MySQL Reference Manual :: 7.2.16 Speed of DELETE Statements
Search the MySQL manual:
- 7.2 Optimizing SELECT Statements and Other Queries
- 7.2.1 EXPLAIN Syntax (Get Information About a SELECT)
- 7.2.2 Estimating Query Performance
- 7.2.3 Speed of SELECT Queries
- 7.2.4 How MySQL Optimizes WHERE Clauses
- 7.2.5 Range Optimization
- 7.2.6 Index Merge Optimization
- 7.2.7 How MySQL Optimizes IS NULL
- 7.2.8 How MySQL Optimizes DISTINCT
- 7.2.9 How MySQL Optimizes LEFT JOIN and RIGHT JOIN
- 7.2.10 How MySQL Optimizes ORDER BY
- 7.2.11 How MySQL Optimizes GROUP BY
- 7.2.12 How MySQL Optimizes LIMIT
- 7.2.13 How to Avoid Table Scans
- 7.2.14 Speed of INSERT Statements
- 7.2.15 Speed of UPDATE Statements
- 7.2.16 Speed of DELETE Statements
- 7.2.17 Other Optimization Tips
Additional languages
Additional formats
The time to delete individual records is exactly proportional to the number of indexes. To delete records more quickly, you can increase the size of the key cache. See Section 7.5.2, “Tuning Server Parameters”.
If you want to delete all rows in the table, use TRUNCATE TABLE tbl_name rather than DELETE FROM .
See Section 13.1.9, “tbl_nameTRUNCATE Syntax”.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Add your own comment.