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: stats_change_threshold = <number>
Default: 50
The value must be greater than zero.
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