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 http://www.mysql.com/ is continually updated.)

The MySQL query ...

Get MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.