Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 33.0Mb
PDF (A4) - 33.0Mb
PDF (RPM) - 31.0Mb
HTML Download (TGZ) - 7.9Mb
HTML Download (Zip) - 7.9Mb
HTML Download (RPM) - 6.7Mb
Man Pages (TGZ) - 143.7Kb
Man Pages (Zip) - 203.9Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb


MySQL 8.0 Reference Manual  /  Optimization  /  Controlling the Query Optimizer

Pre-General Availability Draft: 2017-08-22

8.9 Controlling the Query Optimizer

MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model.

The server also maintains statistics about column values, although the optimizer does not yet use this information.


User Comments
  Posted by Richard Prout on July 30, 2008
I had a view with probably 20 joins in. tables typically only had 100 rows. query would initially take 20-30seconds. i set the optimiser search depth down to 3 and got that time down to 90ms.
Sign Up Login You must be logged in to post a comment.