Analyze Table
Enables automatic computation of table statistics using the ANALYZE TABLE command to improve query performance.
When enabled, the generated load processes append ANALYZE TABLE ... COMPUTE STATISTICS for the target table after the load completes. This applies across the layers: staging, persistent staging, and the Data Vault loads.
When to Change This Setting
Keep the default N when statistics maintenance is handled elsewhere or load duration is the priority. Enable it when query planning against the loaded tables benefits from fresh statistics and the extra step per load is acceptable.
Related Settings
| Setting | Interaction |
|---|---|
| Optimize Table | The companion post-load OPTIMIZE file-compaction step |
Notes
- This setting is part of the Databricks settings category.
- The default value for this setting is
N.