A great link for getting to know the design and architecture of the Clustered Columnstore Index.
SQL Server Column Store Indexes - Microsoft Research
All the sections are interesting, the Batch mode processing updates and how updates and deletes are handled gives you an idea of how it is entirely different from the traditional B-Tree row store.
Other Links in the Clustered Column Store Series:
"Clustered Columnstore Indexes" Limitations
Clustered Columnstore Index - Delta Store explained
Other Links in the Clustered Column Store Series:
"Clustered Columnstore Indexes" Limitations
Clustered Columnstore Index - Delta Store explained
No comments:
Post a Comment