Part 04 · Query Processing and Optimization
Why the Optimizer Picks a Wrong Plan
Stale statisticsCorrelationParameter sniffingPlan fixes
Stale stats, correlated columns, skewed values and generic plans: real cases where the planner goes wrong on the shop data, and how to fix each one.
⏱ 6 min · Station 34 of 123