Purpose
Specifies whether Teradata Database should determine the appropriate amount of table data to sample for statistics collection. If not, the sample size will be 100%.
This field is used only when a COLLECT STATISTICS SQL statement does not specify the USING SAMPLE option.
Field Group
Optimizer Statistics
Valid Settings
| Setting | Description |
|---|---|
| 0 | Use Teradata default, currently equivalent to setting 1. |
| 1 | Enables system-determined sample percentage up to 100%. |
| 2 | Sample percentage is 100% (full statistics). |
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 Topics
| For more information on… | See… |
|---|---|
| Optimizer statistics fields |