MySQL explain for DELETE queries

Question

Is there a way to explain a DELETE query with MySQL like we can explain a SELECT query?

score 37 · Answer 1 · answered Feb 15 '13 at 19:40

37

"As of MySQL 5.6.3, EXPLAIN provides information about SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. Before MySQL 5.6.3, EXPLAIN provides information only about SELECT statements."

from http://dev.mysql.com/doc/refman/5.6/en/explain.html

answered Feb 15 '13 at 19:40

Niro

756
8
15

score 9 · Accepted Answer · answered Apr 29 '11 at 18:33

Wouldn't the plan for that be the same as for a select 1 where.... with the same condition as your delete query?

The 1 is so the optimizer isn't forced to pull any unneeded columns, it can only look at the columns it needs for the filtering conditions.

MySQL explain for DELETE queries

2 Answers2

Linked