Execution Plans at Scale

Execution Plans at Scale

LEFT JOIN Silently Becomes INNER JOIN

Join Order and Cardinality Estimation

Non-Sargable Predicate Kills Index Usage

Estimated vs Actual Row Counts

CTE Materialization and Optimization Fences

CTE Materialization vs Inlining

Complex Joins, CTEs & Perf Reasoning

Query Performance & Execution Plans

Reading a Query Execution Plan

Indexes and Execution Plans