Show TOC

Syntax documentationstats_change_threshold Locate this document in the navigation structure

This parameter defines the threshold for the percentage of inserted or deleted rows causing an update in optimizer statistics for the BRCONNECT update statistics function.

Syntax Syntax

  1. stats_change_threshold = <number>
End of the code.

Default: 50

The value must be greater than zero.

Example Example

25% means that statistics are collected for a table if either of the following is true:

  • Inserted row count is greater than or equal to 25 % of the old row count

  • Updated row count is greater than or equal to 25 % of the old row count

  • Deleted row count is greater than or equal to 25 / (100*25) % of the old row count

End of the example.