Query Execution Plan

Databases MySQL

Optimizing UPDATE and DELETE statements

Ronald Bradford
February 24, 2011

Updated Nov 2011. Check out my latest book on Optimizing SQL Statements for more information. MySQL 5.6.2 also now provides an EXPLAIN syntax for UPDATE and DELETE statements natively. While most people look at performance optimizations for SELECT statements, UPDATE and DELETE statements are often overlooked.