Columnstore index – SQL Performance


The BI and SQL blog

Pain: Performance tuning

SQL DBA’s email to SQL Developer “Your query is too slow and eating up server resources. Please tune it”

Dream:

Senior SQL DBA’s email to SQL Developer “Your query is too fast. Slow it down :P”

Fix:

Well there are thousands or should I say tens of thousands of ways to do performance tuning of SQL queries. Almost every SQL developer has to do it.

I will just cover one out of the box feature called ColumnStore Index  introduced by Microsoft SQL Server 2012.

As we all know, Indexes are used to help SQL engine to create efficient query plans thus giving optimal result. So I wont go into basics of indices here as its a big subject as a whole.

To understand columnstore index, first we need to understand how index works.

Prior to SQL Server 2012. whenever a table was applied with index (for particular column or…

View original post 146 more words

Advertisements

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