January 2019
Intermediate to advanced
286 pages
7h 41m
English
Content preview from Advanced MySQL 8
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,
Start your free trial
Case study 1 – how to use the EXPLAIN plan tool in MySQL 8.0
As we have already explained in our previous sections, EXPLAIN describes how MySQL plans to execute any query. That is, it is a pre-execution tool, without affecting the performance of your database, not to compare with the profiling of a query that is another tool of MySQL.
The following table shows the EXPLAIN syntax in the most important versions of MySQL: