Hint-based Tuning

Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Skew Hints
Configuration Parameter Hints
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases

Parent topic: Query Improvement