content_image/843256.jpg content_image/843257.jpg content_image/843258.jpg content_image/843259.jpg
<img src='content_image/843256.jpg'>

The size specified by IndexStatSaveSize  is scaled by the value of IndexStatTriggerPct  for a large index, times 0.01. This is further multiplied by the logarithm to the base 2 of the index size. Setting IndexStatTriggerPct  equal to 0 disables the scaling effect. 

• IndexStatTriggerPct 

<img src='content_image/843257.jpg'>

Percentage change in updates that triggers an index statistics update. The value is scaled by IndexStatTriggerScale . You can disable this trigger altogether by setting IndexStatTriggerPct to 0. 

• IndexStatTriggerScale 

<img src='content_image/843258.jpg'>

Scale IndexStatTriggerPct  by this amount times 0.01 for a large index. A value of 0 disables scaling. 

• IndexStatUpdateDelay 

<img src='content_image/843259.jpg'>

Minimum delay in seconds between automatic index statistics updates for a given index. Setting this variable to 0 disables any delay. The default is 60 seconds. 

Restart types.  Information about the restart types used by the parameter descriptions in this section is shown in the following table: 

