If you're having trouble reading the output of the EXPLAIN command in MySQL, just copy and paste it into the Explain Analyzer hosted over at the MariaDB site. You then click on the various fields displayed, and it will explain what they mean.
For those who don't know, MariaDB is a fork of MySQL. The project is headed by Monty Widenius, the original creator of MySQL.
Post a Comment