What is very important in the field of optimization is to understand how the MySQL optimizer thinks when using the tools that are available, such as EXPLAIN.
In addition to understanding and familiarizing yourself with the MySQL EXPLAIN tool, you must apply the steps we explained in organizing your columns in the order in which you use the WHERE, GROUP BY, and ORDER BY commands.
We also shared the new MySQL 8.0 features for EXPLAIN and other components.
In the next chapter, we will show you advanced performance techniques for the large queries that you can use in your projects.
