Skip to main content
IN PREVIEW

Ordered Clustered Columnstore Indexes for Azure SQL Data Warehouse is now in preview

Published date: May 08, 2019

Columnstore is a key enabler for storing and efficiently querying large amounts of data. For each table, it divides the incoming data into Row Groups and each column of a Row Group forms a Segment on a disk. Ordered clustered columnstore indexes further optimize query execution by enabling efficient segment elimination.   For more information, see:

CREATE TABLE (Azure SQL Data Warehouse)
CREATE COLUMNSTORE INDEX (Transact-SQL).

Read the blog announcement

  • Azure Synapse Analytics
  • Features