Skip Navigation

General availability: Automatic creation of statistics in SQL Data Warehouse

Monday, May 14, 2018

Statistics provide necessary information for Azure SQL Data Warehouse to build optimal query plans. Historically, this has required analysis of queries and manual creation of statistics.
 
Azure SQL Data Warehouse now supports the automatic creation of column-level statistics. This feature enables the cost-based optimizer to build query plans that run faster and make efficient use of resources.
 
For more information about the general availability of this feature, see the full blog post.
 
For more information about statistics objects in Azure SQL Data Warehouse, including the process of automatic statistics creation, see the documentation.

Free account

Get $200 in Azure credits and 12 months of popular services—free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Startups

Join Microsoft for Startups and get free Azure services

Learn more