Article Source

• Statistics 04 - About the Cardinality Estimator

What is the Cardinality Estimator?

Abstract

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.