advanced~2h
Optimizer Hints & Query Rewriting
When a hint is actually the right tool versus a sign you're fighting the optimizer, plus the rewriting techniques that usually fix a slow query without needing a hint at all.
Learning objectives
- Explain why hints are a last resort rather than a first move in tuning
- List common query rewriting techniques that remove the need for a hint entirely
- Rewrite a correlated subquery as a join and explain the performance implication
- Explain why wrapping a function around an indexed column disables that index
- Walk through a full worked example from a slow query to a tuned one
This is a Pro chapter
Sign in, then upgrade to Pro or Power to unlock this and the full Databases Mastery library.
Optimizer Hints & Query Rewriting