Clustered Columnstore Index in Azure SQL Database
Columnstore index is the preferred technology to run analytics queries in Azure SQL Databases. We recently announced general availability of In-Memory technologies for all Premium databases. Similar to In-Memory OLTP, the columnstore index technology is not available in databases in the Standard and Basic pricing tiers today.
Please refer to the blog https://azure.microsoft.com/en-us/blog/clustered-columnstore-index-in-azure-sql-database/ for the details on columnstore index in Azure SQL Database
SQL Server Tiger Team