Columnstore index in SQL Server 2012

added by kalyanms1
7/5/2012 8:59:52 AM


Microsoft SQL Server 2012 introduces a new Index type called Columnstore and it offers great performance for data-warehousing loads and other similar queries. Columnstore indexes are designed for data-ware house workloads that are typically read based. This post discuss about how Columnstore index work, how the data is stored in it and what type of queries can benefit from a column store index. It also discusses how to create Columnstore index in SQL Server 2012.