12 items
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
How the optimizer picks plans and why they degrade as data volume, skew, and stale statistics grow.
