STORAGE.TABLE_STATISTICS_OPTIONS
Target database: Azure SQL Database, Azure Synapse SQL
STORAGE.TABLE_STATISTICS_OPTIONS is used to define table statistics options.
See also:
Usage
OPTION
STORAGE.TABLE_STATISTICS_OPTIONS: sql_code
Notes
Table statistics can be created for tables and materialized views in supported target databases.
Examples
Defining table statistics options
Configuring CREATE STATISTICS arguments with STORAGE.TABLE_STATISTICS_OPTIONS, for example:
OPTION
STORAGE.TABLE_STATISTICS_OPTIONS: FULLSCAN, NORECOMPUTE
DDL generated by Agile Data Engine:
SQL
CREATE STATISTICS ...
WITH FULLSCAN, NORECOMPUTE;