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.
Disable updating statistics in entity recreate
Update in entity recreate set to false:
Table statistics have been previously defined for an entity and a deployment that triggers entity recreate is executed:
... CREATE STATISTICS ... WITH SAMPLE 0 ROWS;
When 0 ROWS is specified, the statistics object is created but it does not contain statistics data.