Automatic collection of index statistics

{question}

Can the automatic collection of index statistics be disabled?

{question}

 

{answer}

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.

The parameter 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 disable-stats-collection and max-full-gc-skips configuration parameters, see Database Options.

 

{answer}

Have more questions? Submit a request

Comments