The ANALYZE TABLE ... COMPUTE STATISTICS statement gathers statistics on a table and its columns so the cost-based optimiser can plan queries better. On Unity Catalog managed tables, predictive optimization runs ANALYZE for you.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ANALYZE TABLE in context, with comparison tables and the common traps.
Terms in this definition
- Statistics
Information about how values are distributed in a column, which the warehouse optimiser uses to estimate plan costs. Fabric builds and updates it for you; manual CREATE, UPDATE and DROP STATISTICS are limited to single-column histograms.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- Predictive optimization
Unity Catalog managed tables can have
OPTIMIZE,VACUUMandANALYZEscheduled and run for them on serverless compute without manual effort. Accounts created on or after 11 November 2024 get this turned on by default. - Agents (classic) API
First-generation Foundry Agent Service API, based on threads, messages and runs. It is deprecated, replaced by conversations and responses, and retires on 31 March 2027.