SQLShorts: SQL 2012 Apollo Column Store
- Posted: Dec 10, 2011 at 12:23 PM
- 2,386 Views
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.