Mike's Database Place

MySQL EXPLAIN

Databases

MySQL

MySQL Diagnostics & Tuning

MySQL Optimizer

EXPLAIN

SELECT mycolumn

FROM mytable

WHERE mycolumn = 'myvalue';

EXPLAIN FORMAT=JSON

SELECT mycolumn

FROM mytable

WHERE mycolumn = 'myvalue';

EXPLAIN FORMAT=TREE

SELECT mycolumn

FROM mytable

WHERE mycolumn = 'myvalue';

Not available in 5.7 and earlier

EXPLAIN ANALYZE

SELECT mycolumn

FROM mytable

WHERE mycolumn = 'myvalue';

Bibliography

https://www.mydbops.com/blog/demystifying-mysqls-explain-formattree-and-understanding-query-execution/https://dev.mysql.com/blog-archive/mysql-explain-analyze/https://oysteing.blogspot.com/2021/09/run-analyze-table-do-not-rely-on.htmlhttps://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html

Page updated

Google Sites

Report abuse