New Cardinality Estimation Logic
The release of SQL Server 2014 brings with it the first new re-design of the Cardinality Estimator since SQL Server 7.0. The cardinality estimation logic has been re-designed in SQL Server 2014 to improve the quality of query plans and ostensibly, query performance. The new cardinality estimator is based on in-depth cardinality estimation research based on what Microsoft has seen and learned over the past 15 years. The new cardinality estimator incorporates assumptions and algorithms that work well on modern OLTP and data warehousing workloads. A completed list of all changes has not been documented, and some are proprietary, but some of the changes are highlighted in Chapter 32, “Indexes and Performance,” and ...
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.
