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 BRCONNECT update statistics.

Syntax Syntax

  1. stats_change_threshold = <number>
End of the source 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.