Clustered Columnstore Index

GPTKB entity

Statements (23)
Predicate Object
gptkbp:instanceOf database index type
gptkbp:cannotCoexistWith rowstore clustered index
gptkbp:coexistedWith nonclustered rowstore indexes
gptkbp:enables data compression
batch mode processing
real-time operational analytics
https://www.w3.org/2000/01/rdf-schema#label Clustered Columnstore Index
gptkbp:improves query performance
gptkbp:introducedIn gptkb:SQL_Server_2014
gptkbp:reduces storage requirements
gptkbp:replacedBy rowstore clustered index
gptkbp:requires Enterprise Edition for some features
gptkbp:storesDataAs columns
gptkbp:supports partitioning
update operations
delete operations
insert operations
gptkbp:usedFor data warehousing
analytics workloads
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkb:Azure_SQL_Database
gptkbp:bfsParent gptkb:Columnstore_Indexes
gptkbp:bfsLayer 8