This parameter defines the sample size with the BRCONNECT update statistics function using method E for tables that are not specified in the DBSTATC control table.
Syntax
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
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.