What’s New in Query Optimization
New in SQL Server 2014 is the redesign of Cardinality Estimator. The Cardinality Estimator is the component that predicts the final row count and row counts of intermediate results (such as joins, filtering, and aggregation) for your queries. These estimates have a direct impact on the query plan choices made by the query optimizer such as join order, join type, etc. The updated Cardinality Estimator is designed to improve the quality of query plans and ostensibly, query performance. This is the first real update to the Cardinality Estimator since SQL Server 7.0.
The new Cardinality Estimator logic is based on in-depth cardinality estimation research on modern workloads and Microsoft learnings over the past 15 ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
