Clustered Columnstore indexes is one of the best things that happened to SQL server for Data Warehousing applications. But having said that there are a few limitations that have to be kept in mind:
Columns that use any of the following data types cannot be included in a columnstore index.
- ntext, text, and image
- varchar(max) and nvarchar(max)
- rowversion (and timestamp)
- sql_variant
- CLR types (hierarchyid and spatial types)
- xml
Columnstore indexes cannot be combined with the following features:
- Page and row compression, and vardecimal storage format (A columnstore index is already compressed in a different format.)
- Replication
- Change tracking
- Change data capture
- Filestream
Other Links in the Clustered Column Store Series:
Internals of Clustered Column Store Index
Clustered Columnstore Index - Delta Store explained
Internals of Clustered Column Store Index
Clustered Columnstore Index - Delta Store explained
No comments:
Post a Comment