Using columnstore indexes and batch processing
Columnstore indexes, a new feature in SQL Server 2012, were introduced in Chapter 7 and touched on again in Chapter 8. This section shows you the query processing aspect of the technology. As explained at the beginning of this chapter, the standard query processing mode in all versions of SQL Server uses a row-at-a-time model; operators process only one row at a time. Columnstore indexes are complemented with a new vector-based query execution capability with operators that can process batches of rows at a time. In addition to the I/O performance improvements, the new query processing capabilities also provide some benefits because columnstore indexes are compressed and typical data warehouse queries ...
Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
