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

Coffee and SQL

I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

70-457 Reviewer #02, What is Columnstore Index?

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index geared toward increasing query performance involving large result sets, ideally in fact tables for OLAP query. This type of index is based on Vertipaq engine acquisition. Columnstore indexes in the SQL Server Database Engine can […]

Comments

Leave a comment on the original post [coffeeandsql.com, opens in a new window]

Loading comments...