O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

What’s New for Data Structures, Indexes, and Performance

SQL Server 2012 provides only a few new features and enhancements related to data structures, indexes, and performance.

The main new feature is xVelocity columnstore indexes. This new index, combined with enhanced query processing features, can improve data warehouse query performance by hundreds to thousands of times in some cases and can routinely provide a tenfold speedup for a broad range of decision support queries. Columnstore indexes can limit or eliminate the need to rely on prebuilt aggregates, including user-defined summary tables, and indexed (materialized) views. This chapter describes the physical structure of columnstore indexes and how they improve performance for data warehouse ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required