STORAGE.TABLE_STATISTICS_WHERE
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
OPTION
STORAGE.TABLE_STATISTICS_WHERE: sql_codeNotes
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:
OPTION
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'
...
;