Skip to main content
Skip table of contents

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.

JavaScript errors detected

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

If this problem persists, please contact our support.