STORAGE.TABLE_STATISTICS_OPTIONS

Target database: Azure SQL Database, Azure Synapse SQL, Microsoft Fabric, Databricks SQL

STORAGE.TABLE_STATISTICS_OPTIONS is used to define table statistics options.

See also:

• Statistics (Microsoft documentation)

• CREATE STATISTICS (Microsoft documentation)

• ANALYZE TABLE (Databricks Microsoft documentation)

• STORAGE.TABLE_STATISTICS_UPDATE_IN_ENTITY_RECREATE

Usage

STORAGE.TABLE_STATISTICS_OPTIONS: sql_code

Notes

Table statistics can be created for tables and materialized views in supported target databases.

Examples

Azure SQL Database, Azure Synapse SQL, Microsoft Fabric:
Defining table statistics options

Configuring CREATE STATISTICS arguments with STORAGE.TABLE_STATISTICS_OPTIONS, for example:

STORAGE.TABLE_STATISTICS_OPTIONS: FULLSCAN, NORECOMPUTE

DDL generated by Agile Data Engine:

CREATE STATISTICS ...
WITH FULLSCAN, NORECOMPUTE;

Databricks SQL: Defining table statistics options

Requires the option STORAGE.SORTKEY_RECLUSTER_IN_ENTITY_RECREATE and will be triggered only in the entity recreation scenario

Example case:

Attribute list defined as option value:

STORAGE.TABLE_STATISTICS_OPTIONS: NOSCAN

DDL generated by Agile Data Engine:

ANALYZE publish.F_TRIP COMPUTE STATISTICS NOSCAN;