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:
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:
SQL
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:
|
Property |
Value |
|---|---|
|
Target entity |
publish.F_TRIP |
|
Statistics option |
NOSCAN |
Attribute list defined as option value:
STORAGE.TABLE_STATISTICS_OPTIONS: NOSCAN
DDL generated by Agile Data Engine:
ANALYZE publish.F_TRIP COMPUTE STATISTICS NOSCAN;