SQLShorts: SQL 2012 Apollo Column Store

Download

Right click “Save as…”

The SQL Server columnstore index feature, code-named Apollo, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012, code-named "Denali", in many cases by a factor of 10 to 100.

 

http://social.technet.microsoft.com/wiki/contents/articles/sql-server-columnstore-index-faq.aspx

Tag:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.