STORAGE.TABLE_STATISTICS_ATTRIBUTES
Metadata_Start
Target database: Azure SQL Database, Azure Synapse SQL
STORAGE.TABLE_STATISTICS_ATTRIBUTES is used to define attributes to be included in table statistics.
See also:
Usage
OPTION
STORAGE.TABLE_STATISTICS_ATTRIBUTES: sql_codeNotes
Table statistics can be created for tables and materialized views in supported target databases.
Examples
Defining attributes to be included in table statistics
Example case:
Property | Value |
|---|---|
Target entity | publish.F_TRIP |
Statistics attributes | pulocationid, dolocationid |
Attribute list defined as option value:
OPTION
STORAGE.TABLE_STATISTICS_ATTRIBUTES: pulocationid, dolocationid DDL generated by Agile Data Engine:
SQL
CREATE STATISTICS [ADE_PUBLISH_F_TRIP_STATS] ON [publish].[F_TRIP] (pulocationid, dolocationid);