STORAGE.TABLE_STATISTICS_UPDATE_IN_ENTITY_RECREATE

Target database: Azure SQL Database, Azure Synapse SQL

STORAGE.TABLE_STATISTICS_UPDATE_IN_ENTITY_RECREATE is used to control whether table statistics are updated in entity recreate. Entity recreation is triggered by the deployment of some entity changes.

See also:

Usage

OPTION

STORAGE.TABLE_STATISTICS_UPDATE_IN_ENTITY_RECREATE: Boolean

Default: true

Notes

Table statistics can be created for tables and materialized views in supported target databases.

Examples

Disable updating statistics in entity recreate

Update in entity recreate set to false:

OPTION

STORAGE.TABLE_STATISTICS_UPDATE_IN_ENTITY_RECREATE: false

Table statistics have been previously defined for an entity and a deployment that triggers entity recreate is executed:

SQL

...
CREATE STATISTICS ...
WITH SAMPLE 0 ROWS;

When 0 ROWS is specified, the statistics object is created but it does not contain statistics data.