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