Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Daily Denali Delight – Day 3

Code-named Denali – the next version of SQL Server is fast approaching.

And whenever CTP2 gets released you can be sure to expect some excellent new features.

Over the next week or so, I aim to delve into these delights, highlighting those to look out for.

Columnar Indexes

Dubbed as one of the more important new features that Denali has to offer, Columnar Indexes combine high performance and high compression to offer vastly improved query performance.

Indexed data is stored column-wise and only the needed columns are returned as query results for columnar indexes.

Seems like it can be a very big win in DataWarehouse environments ?!

Comments

Posted by rwb1912 on 15 May 2011

Now this is very interesting. There are already a couple of instances where I can see this being a very useful performance enhancement. My only concern here would be to ensure balance between number of indexes without causing performance bottle necks. I can see though how you could create a perfect combination of row indexes couple with column indexes to maximize performance.

Leave a Comment

Please register or log in to leave a comment.