© Dmitri Korotkevitch 2018
Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_14

14. Locking in Columnstore Indexes

Dmitri Korotkevitch1 
Land O Lakes, Florida, USA

Columnstore indexes are a type of index that stores data on a per-column rather than per-row basis. This storage format benefits query processing in data warehousing, reporting, and analytics environments where, although queries typically read a very large number of rows, they work with just a subset of the columns from a table.

This chapter will provide an overview of column-based storage and discuss the locking behavior of columnstore indexes and their usage in OLTP systems.

Column-Based Storage Overview

Even though every database ...

Get Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners now with O’Reilly online learning.

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