Clustered Columnstore Indexes

SQL Server 2019 features in-memory columnstore indexes. Columnstore indexes store and manage data by using columnar data storage and columnar query processing. Data warehouse workloads that primarily perform bulk loads and read-only queries will very likely benefit from columnstore indexes. Use the columnstore index to achieve up to 10x query performance gains over traditional row-oriented storage and up to 7x data compresson over the uncompressed data size.

SQL Server supports both clustered and nonclustered columnstore indexes. Both use the same in-memory columnstore technology, but they do have differences in purpose and in features they support.

For example, a clustered columnstore index is the physical storage for the table and is the only index for the table. The clustered index is updatable so you can perform insert, delete, and update operations on the index.

Conversely, a nonclustered columnstore index is a read-only index created on...