8.9 Controlling the Query Optimizer

8.9.1 Controlling Query Plan Evaluation
8.9.2 Controlling Switchable Optimizations
8.9.3 Index Hints

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