Show TOC

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

            stats_change_threshold = <threshold> | (<threshold> [, all_part:<threshold>
            | info_cubes:<threshold> | [<owner>.]<table>:<threshold>
            | [<owner>.][<prefix>]*[<suffix>]:<threshold>
            | <tablespace>:<threshold> | <object_list>])

Default: 50

The value must be greater than zero. You can define one global change threshold for all tables - for example, stats_change_threshold = 40 - or you can define a different change threshold for certain groups of tables.

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