Specifying the SAMPLING SIZE
- The min value that you specify immediately after the SAMPLING SIZE keywords
- The sampling size that is required for the default percent of rows in each bin (2.5%) and for the minimum confidence level (0.80).
- The min value that you specify immediately after the SAMPLING SIZE keywords
- The sampling size that is required for the specified percent of rows and for the specified confidence level.
If a sampling size is specified in a Resolution clause that includes an average percentage value but sets no confidence level, then the minimum confidence value of 0.80 is used to calculate the actual sampling size for HCL OneDB to use if the specified size is smaller.
UPDATE STATISTICS MEDIUM FOR TABLE customer (city, state) SAMPLING SIZE 200 RESOLUTION 2 DISTRIBUTIONS ONLY;
Whether or not you include an explicit SAMPLING SIZE specification in the Resolution clause, HCL OneDB records in the system catalog the actual sampling size (as a percentage of the total number of rows in the table) at the time of MEDIUM mode UPDATE STATISTICS creation.