O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, 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

Columnstore Indexes

SQL Server 2012 introduced a new query acceleration feature based on a type of index called a columnstore index. Columnstore indexes, combined with enhanced query processing features, can improve query performance for data warehouse applications significantly. Columnstore indexes can eliminate the need to rely on other data warehousing strategies such as prebuilt aggregates, summary tables, and indexed views.

In SQL Server 2012, columnstore indexes were limited to nonclustered columnstore indexes only and tables with a nonclustered columnstore index could not be updated. To update the data, you had to drop and rebuild the index or swap out partitions. In SQL Server 2014, this feature was enhanced to allow the creation of clustered ...

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