EXPLAIN options
I will not describe the EXPLAIN options in detail again, because we have already done so in the How to efficiently read MySQL query execution plans section. However, I will explore the most important options that DBAs and developers are not used to working with, and give you a better understanding of EXPLAIN so that you can manage it properly.
The DESCRIBE and EXPLAIN commands are synonyms or similar. In practice, DESCRIBE is often used to get a quick overview of the table structure, while EXPLAIN is used to get a pre-execution of queries expressed as a plan.
In the preceding table, we have an option that is new since MySQL 5.7, and this option is FOR CONNECTION connection_id. As you may have probably noticed, this option ...
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