CHAPTER 35

image

Clustered Columnstore Indexes

It is impossible to modify data in tables with nonclustered columnstore indexes. This limitation is one of the major factors preventing their widespread adoption in SQL Server 2012. SQL Server 2014 addresses this problem by introducing updatable clustered columnstore indexes (CCI).

This chapter provides an overview of the internal structure of CCI and discusses best practices for data loading and maintenance of them.

Internal Structure of Clustered Columnstore Indexes

A clustered columnstore indexis a single instance of the data in a table. Tables with clustered columnstore indexes cannot have any other ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.