Is there a way to explain a DELETE query with MySQL like we can explain a SELECT query?
DELETE
SELECT
"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