Show TOC

Syntax documentationstats_sample_size Locate this document in the navigation structure

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 Syntax

  1. stats_sample_size = P<p>|R<r>
End of the code.

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 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.

End of the note.