Enhancements to SQL Server Column Stores

SQL Server 2012 introduced two innovations targeted for data warehousing workloads: column store indexes and batch (vectorized) processing mode. Together they greatly improve performance of typical data warehouse queries, routinely by 10X and in some cases by a 100X or more. The main limitations of the initial version are addressed in the upcoming release. Column store indexes are updatable and can be used as the base storage for a table. The repertoire of batch mode operators has been expanded, existing operators have been improved, and query optimization has been enhanced. This paper gives an overview of SQL Server’s column stores and batch processing, in particular the enhancements introduced in the upcoming release.

Apollo3 - Sigmod 2013 - final.pdf
PDF file

Publisher  ACM SIGMOD
SIGMOD’13, June 22-27, 2013, New York, New York, USA. Copyright © ACM 978-1-4503-2037-5/13/06…$15.00.

Details

TypeInproceedings
> Publications > Enhancements to SQL Server Column Stores