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