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

Posted on Wednesday, May 8, 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

  • SQL Data Warehouse
  • Features
  • Microsoft Build