O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required