05. What Is the Cardinality Estimator? (5m)
The CE’s job is to use statistics to determine how many rows will come back for any given operation in a query plan. SQL Server’s Cardinality Estimator changed a lot in 2014, and you need to understand which CE you’re using before you analyze your statistics.
- 01. A Tale of Two Plans (7m)
- 02. Getting to Know Statistics (15m)
- 03. Combining Multiple Single-Column Statistics (8m)
- 04. Multi-Column Statistics and the Cardinality Estimators (14m)
- 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)
4 Comments. Leave new
Is this video supposed to go before 03. Combining Multiple Single-Column Statistics? It feels out-of-place to introduce the cardinality estimator after you’ve deeply explored two applications in video 03 and 04.
Piffany – I thought they worked well as-is, but we can think about reworking ’em. Thanks for the feedback!
I thought the same thing.
In my previous reply, I meant I totally agree with piffany.