Specifies whether Vantage should automatically determine an appropriate data change threshold for statistics recollection.
This field is used only if the DefaultUserChangeThreshold setting is disabled (set to zero) when a COLLECT STATISTICS SQL statement does not specify the USING THRESHOLD PERCENT option.
Field Group
Optimizer Statistics
Settings
Value | Description |
---|---|
0 | Use Teradata default, currently equivalent to setting 1. |
1 | Enables system-determined change threshold checking in statistics collection when DBQL ObjectUsage (update/delete/insert counts) is enabled. |
2 | Enables system-determined change threshold checking in statistics collection regardless of ObjectUsage setting in DBQL logging options. |
3 | Disables system-determined change threshold. |
Default
0
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
Statistics are used by the optimizer to improve query performance.
Related Information
For more information on… | See… |
---|---|
Optimizer statistics fields |