Show TOC

stats_sample_sizeLocate this document in the navigation structure

This parameter defines the sample size with BRCONNECT update statistics using method E for tables that are not specified in the DBSTATC control table.

stats_sample_size = P<p>|R<r>

Default value: internal rules determine the sample size, as with stats_method

Possible values:

  • P<p>: percentage of rows, where <p> is from 1 to 100 and from .001 to .999

  • R<r>: thousands of rows

Note

You can set the percentage of rows to less than 1, which improves performance on very large tables. For more information, see Sample Sizes for Update Statistics.

For example, to set the sample size to 0.05%, enter -s P.05.