Skip to main content
Skip table of contents

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;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.