General availability: Automatic creation of statistics in SQL Data Warehouse

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.