Secondary Indexes on Column Store accelerate SQL Data Warehouse look up queries

added by DotNetKicks
12/5/2016 4:09:18 PM

1 Kicks, 311 Views

We are pleased to announce that Azure SQL Data Warehouse now supports the creation of secondary B-Tree indexes (also referred to as non-clustered indexes or NCI) on column store tables (also referred to as clustered column store indexes or CCI).