Learn More About the SQL Server Cardinality Estimator

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES

With all the cheerleading and the steady drumbeat of new features being released to Azure, it’s easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relational engine predicts for the number of rows affected by a given operation, including intermediate row sets like those created by filters, aggregations, joins and spool. It’s an essential component of query processing.

READ MORE…

Originally Posted in DBTA Magazine May 14, 2015

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.