The MySQL Query Optimizer

When you issue a query to select rows, MySQL analyzes it to see if it can take advantage of any optimizations that will allow it to process the query more quickly. In this section, we'll look at how the query optimizer works. For additional information, consult the chapter "Getting Maximum Performance from MySQL" in the MySQL Reference Manual. That chapter describes various optimization measures that MySQL takes. Information is added to the chapter from time to time because the MySQL developers keep making the optimizer smarter, and it's worth revisiting the chapter occasionally to see if there are any new tricks you can use. (The online MySQL manual at is continually updated.)

The MySQL query ...

Get MySQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.