Columnstore Indexes

GPTKB entity

Statements (38)
Predicate Object
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