What’s New for Indexes and Performance
SQL Server 2014 provides only a few enhancements related to indexes and performance. One new enhancement is clustered columnstore indexes, which was discussed in the previous chapter and also in Chapter 51, “Parallel Data Warehouse.”
SQL Server 2014 also introduces new cardinality estimation logic. The cardinality estimator 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 on modern workloads and Microsoft learnings over the past 15 years. The new cardinality estimator incorporates assumptions and algorithms that work well on modern OLTP and data warehousing workloads. ...
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.
