Syntax documentationstats_change_threshold

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 = <threshold> | (<threshold> [, all_part:<threshold>
  2. | info_cubes:<threshold> | [<owner>.]<table>:<threshold>
  3. | [<owner>.][<prefix>]*[<suffix>]:<threshold>
  4. | <tablespace>:<threshold> | <object_list>])
End of the code.

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