SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Learning about the Cardinality Estimator

By Site Owners,

The Cardinality Estimator is a part of the query processos that helps to generate an appropriate query plan. This is important for producing the most efficient performance for your queries.

We have included a number of links that can help you learn more about the AlwaysOn suite of technologies, broken out by SQL Server version where applicable. 

If you find broken links or have additional suggestions for information, please leave a comment in the discussion for this article.

SQL Server 2016

Continue learning more about SQL Server

View the index of features for the various versions.

Total article views: 182 | Views in the last 30 days: 5
Related Articles

SQL Server 2014 Cardinality Estimator

SQL Server 2014 Cardinality Estimator The SQL Server 2014 cardinality estimator has been improved...


Cardinality Estimator – What’s new in SQL Server 2014

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are t...


The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found......


Fixing Cardinality Estimation Errors with Filtered Statistics

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings ...


Cardinality Estimation – Table Variable Vs Temporary Table in SQL Serve

SQL Server creates and maintains statistics for temporary tables, which lead to better cardinality e...