期刊名称:Bulletin of the Technical Committee on Data Engineering
出版年度:2012
卷号:35
期号:01
出版社:IEEE Computer Society
摘要:SQL Server 2012 introduces a new index type called a column store index and new query operators that
efficiently process batches of rows at a time. These two features together greatly improve the performance
of typical data warehouse queries, in some cases by two orders of magnitude. This paper outlines
the design of column store indexes and batch-mode processing and summarizes the key benefits this
technology provides to customers. It also highlights some early customer experiences and feedback and
briefly discusses future enhancements for column store indexes.