Clustered Columnstore Index in SQL Server 2014

The clustered columnstore index which shipped with SQL Server 2014 is busy revolutionizing the Data Warehousing landscape in SQL Server. When creating a Fact Table in a data warehouse you will almost without question put a Clustered Columnstore (CCI) on the table instead of the traditional Clustered Index.

You get numerous benefits when using a CCI index. Below are a few of these benefits.

  • 90 % compression on the data
  • Lightning fast aggregate queries
  • The index is write-enabled. You can thus run insert, update and delete queries against the table unlike the Non-Clustered Columnstore index in SQL Server 2012

The clustered columnstore index changes the internals of the table structure completely. Instead of the traditional row based heap type storage the clustered columnstore index stores the data in a columnar fashion.

If you have not used Clustered Columnstore Indexes yet then this is definitely worth trying out on your Data Warehouse. Stay posted for more blogs on this topic.

Additional Reading

Advertisements
This entry was posted in SQL Server 2014 and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s