AutoStatsForFixedStatsTable

Determine whether to gather collected statistics for tables that already have a set of fixed statistics.

Synopsis

[SQL]    AutoStatsForFixedStatsTable=n

n is either 0 or 1. The default value is 1.

Description

When AutoStatsForFixedStatsTable is enabled, the automatic collected statistics utility gathers and stores collected statistics for tables that have predefined fixed statistics. When it is disabled, the utility neither gathers nor stores such statistics on tables that have predefined fixed statistics.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Disable automatic statistics collection for tables with fixed statistics. to prevent the automatic collected statistics utility from gather statistics for tables that already have a set of fixed statistics.

You can also change AutoStatsForFixedStatsTable by editing the CPF in a text editor (as described in Editing the Active CPF).

AutoStatsForRemoteGlobalTable

AutoStatsForEfficientSamplingTableOnly