Query Optimization & Execution Plans

24 lessons in Databases & SQL

• Composite Index Column Order BugCode Quiz
• Composite Index Column Ordering and RangesQuiz
• Composite Index Column Order BugCode Quiz
• Composite Index Column OrderQuiz
• EXPLAIN Plans & Composite IndexesSlides / Video
• Composite Indexes & Column OrderFlashcard
• Partition Pruning Defeated by a FunctionCode Quiz
• Diagnosing a Skewed Hash Join at ScaleQuiz
• Data Skew and Join Strategy at ScaleFlashcard
• Execution Plans & Optimization at ScaleSlides / Video
• Non-SARGable Predicate Kills IndexCode Quiz
• Diagnosing Slow Plans at ScaleQuiz
• Execution Plans at ScaleFlashcard
• Execution Plans at ScaleSlides / Video
• LEFT JOIN Silently Becomes INNER JOINCode Quiz
• Join Order and Cardinality EstimationQuiz
• Non-Sargable Predicate Kills Index UsageCode Quiz
• Estimated vs Actual Row CountsQuiz
• CTE Materialization and Optimization FencesQuiz
• CTE Materialization vs InliningFlashcard
• Complex Joins, CTEs & Perf ReasoningSlides / Video
• Query Performance & Execution PlansSlides / Video
• Reading a Query Execution PlanQuiz
• Indexes and Execution PlansFlashcard