MySQL explain for DELETE queries

Question

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

Niro · Accepted Answer · 2013-02-15 19:40:59Z

39

"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, 2013 at 19:40

Niro

7768 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Blindy · Accepted Answer · 2011-04-29 18:33:03Z

10

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.

answered Apr 29, 2011 at 18:33

Blindy

68k10 gold badges96 silver badges141 bronze badges

Comments

Jonathan · Accepted Answer · 2022-10-28 13:55:04Z

1

No, that's not quite right. A DELETE would also remove index entries from any associated indexes (mysql erroneously calls them 'keys'). There are also delete triggers to consider as well.

answered Oct 28, 2022 at 13:55

Jonathan

111 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

MySQL explain for DELETE queries

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related