stats_change_threshold

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