Can the automatic collection of index statistics be disabled?
It is possible to disable the automatic collection of index statistics.
The configurable parameters to support this option are disable-stats-collection and max-full-gc-skips.
disable-stats-collection is used to disable automatic index statistics collection for all tables.
The parameter use
max-full-gc-skips is used to control the frequency of record version garbage collection, as deleted records will continue to be reflected in the index statistics until they are garbage-collected.
For more information on using the
max-full-gc-skips configuration parameters, see Database Options.