Blog Post

SQLShorts: SQL 2012 Apollo Column Store

Sign in to queue

Description

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.

 

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

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents