Specifies whether Vantage 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.
|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).|
Changes Take Effect
After the DBS Control Record has been written.
Statistics are used by the optimizer to improve query performance.