01. A Tale of Two Plans (7m)
We look at two execution plans for the same query, talk about why they’re different, and figure out which one makes the most sense.
- 02. Getting to Know Statistics (15m)
- 03. Combining Multiple Single-Column Statistics (8m)
- 04. Multi-Column Statistics and the Cardinality Estimators (14m)
- 05. What Is the Cardinality Estimator? (5m)
- 06. Filtered Statistics: ENHANCE! (15m)
- 07. The Ascending Key Problem (11m)
- 08. 10 Rules for Managing Statistics (12m)
- 09. Seeks, Scans, and Sargability (9m)
- 10. How Execution Plans are Made (10m)