EXPLAIN your SELECT queries
EXPLAIN is a great utility statement in MySQL, which will help us understand the execution plan of the optimizer. This would require SELECT access to view those corresponding tables. With EXPLAIN, you get to know the options/hints for enhancing the performance of your query, such as by adding indexes accordingly to the columns, changing filter criteria for subqueries, the order of joins to be performed, and so on. The result would have all the information required for making decisions such as what kind of select, table name, partitions if they exist, type of columns being used in the where clause, the possible set of keys, the key being used for that query, the number of rows it would have scanned, and the percentage ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access