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 ...
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.
