{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}
Comments