gptkbp:instanceOf
|
Database Index Type
|
gptkbp:benefit
|
Lower storage costs
Faster scan performance
Reduced I/O
|
gptkbp:canBe
|
Filtered
Partitioned
Read-only (in early versions)
Updatable (in later versions)
|
gptkbp:compatibleWith
|
gptkb:Heap_tables_(before_SQL_Server_2016)
Memory-optimized tables
|
gptkbp:compressionRatio
|
Column-level compression
|
gptkbp:dataStorageFormat
|
Columnar
|
https://www.w3.org/2000/01/rdf-schema#label
|
Columnstore Indexes
|
gptkbp:introducedIn
|
gptkb:SQL_Server_2012
|
gptkbp:limitation
|
Limited support for certain data types
Restrictions on updates (improved in later versions)
|
gptkbp:notRecommendedFor
|
OLTP workloads
|
gptkbp:purpose
|
Improve query performance for analytics
|
gptkbp:rowGroup
|
Logical group of rows stored together
|
gptkbp:segmentSize
|
1 million rows per segment (default)
|
gptkbp:supports
|
Data compression
Batch mode processing
Real-time operational analytics
|
gptkbp:supportsMetadata
|
System catalog views
|
gptkbp:type
|
gptkb:Clustered_Columnstore_Index
gptkb:Nonclustered_Columnstore_Index
|
gptkbp:usedFor
|
Data warehousing
OLAP queries
Business intelligence workloads
|
gptkbp:usedIn
|
gptkb:SQL_Server
gptkb:Azure_Synapse_Analytics
gptkb:Azure_SQL_Database
|
gptkbp:bfsParent
|
gptkb:SQL_Server_2014
gptkb:SQL_Server_2016
gptkb:SQL_Server_on_Linux
gptkb:SQL_Server_2014_and_later
gptkb:SQL_Server_2012
|
gptkbp:bfsLayer
|
7
|