© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_33

33. Column-Based Storage and Batch Mode Execution

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Columnstore indexes are an Enterprise Edition feature introduced in SQL Server 2012. They are part of the new family of technologies called xVelocity(formerly known as VertiPaq), which optimizes the performance of analytical queries that scan and aggregate large amounts of data.

Columnstore indexes use a different storage format for data, storing compressed data on a per-column rather than a per-row basis. This storage format benefits query processing in data warehousing, reporting, and analytics environments where, although they typically read a very large ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.