Saturday, May 11, 2013

SQL 2012 New Features - Column Store Indexes

Stores data in columns instead of storing in rows

Enables accessing data in easy and fast manner.

Improves processing time of Data Warehouse (DW) queries by hundreds to thousands times

To improve query performance, you need to build a column store index on the fact tables in a DW.

CREATE COLUMNSTORE INDEX [Index_Name] on [table_name] (Column_Name)

No comments:

Post a Comment