Categories
General

ColumnStore Index

What’s this?
Columnstore index is a new type of index available from the future release of SQL Server known as Denali aka SQL Server 2011. Columnstore index helps data warehouse queries to execute faster than the normal indexes.This index is suited if the volume of data is high and same type of query is used to retrieve the data. Columnstore index is read-only hence DML statements are not possible on the base table hence no OLTP tables please.