Nonclustered Columnstore Index
GPTKB entity
Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Database Index
|
| gptkbp:canBe |
Dropped
Disabled Filtered Rebuilt Partitioned Created on a subset of columns Created on a subset of rows (filtered index) Created on a table with existing clustered index Created on a table with no clustered index (heap) Created with COLUMNSTORE_ARCHIVE option Created with COMPRESSION_DELAY option Created with DATA_COMPRESSION option Created with DROP_EXISTING option Created with MAXDOP option Created with ONLINE option Non-unique Online created (from SQL Server 2019 onwards) Updatable (from SQL Server 2016 onwards) Applied to memory-optimized tables (from SQL Server 2016 onwards) |
| gptkbp:canBeCreatedOn |
gptkb:Heap
Clustered index Partitioned table |
| gptkbp:compatibleWith |
LOB columns
Computed columns (unless persisted) Filestream columns Primary key constraint Row-overflow data Sparse columns Timestamp columns Unique constraint XML columns |
| gptkbp:compressesData |
Yes
|
| gptkbp:enables |
Hybrid transactional and analytical processing (HTAP)
Batch mode execution Faster analytics queries Hybrid transactional and analytical processing Real-time analytics on OLTP tables Significant data compression |
| https://www.w3.org/2000/01/rdf-schema#label |
Nonclustered Columnstore Index
|
| gptkbp:improves |
Query performance for analytics workloads
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2012
|
| gptkbp:storesDataAs |
Columnstore
|
| gptkbp:supports |
Batch mode processing
Real-time operational analytics |
| gptkbp:usedIn |
gptkb:Microsoft_SQL_Server
gptkb:Azure_Synapse_Analytics gptkb:Azure_SQL_Database |
| gptkbp:bfsParent |
gptkb:Columnstore_Indexes
|
| gptkbp:bfsLayer |
8
|