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.

2 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.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}