8.9 Controlling the Query Optimizer

8.9.1 Controlling Query Plan Evaluation
8.9.2 Index Hints

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