8.4 Controlling the Query Optimizer

8.4.1 Controlling Query Plan Evaluation
8.4.2 Index Hints

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