Arun Sirpal takes us through online clustered columnstore index creation in Azure SQL Database:
What tier do you need to create one of these things? Let’s see.
CREATE
CLUSTERED COLUMNSTORE INDEX
cciSales ON
[SalesLT].[ProductModelProductDescription] WITH
( ONLINE = ON
)
But I get this message, Msg 40536, Level 16, State 32, Line 1
‘COLUMNSTORE’ is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Windows Azure SQL Database.
Read on to see the minimum tier which allows online creation of clustered columnstore indexes.