Target database: Azure SQL Database, Azure Synapse SQL
STORAGE.TABLE_STATISTICS_WHERE is used to define a WHERE clause for table statistics.
See also:
Usage
STORAGE.TABLE_STATISTICS_WHERE: sql_code
Notes
Table statistics can be created for tables and materialized views in supported target databases.
Examples
Defining WHERE clause for table statistics
Example case:
|
Property |
Value |
|---|---|
|
Target entity |
publish.F_TRIP |
|
Where clause |
taxi_company = 'Yellow' |
Where clause defined as option value:
STORAGE.TABLE_STATISTICS_WHERE: taxi_company = 'Yellow'
DDL generated by Agile Data Engine:
SQL
CREATE STATISTICS [ADE_PUBLISH_F_TRIP_STATS] ON [publish].[F_TRIP] ...
WHERE taxi_company = 'Yellow'
...
;