AutoStatsForEfficientSamplingTableOnly
Determine whether to collect statistics only from tables that support efficient sampling.
Synopsis
[SQL] AutoStatsForEfficientSamplingTableOnly=n
n is either 0 or 1. The default value is 1.
Description
When AutoStatsForEfficientSamplingTableOnly is enabled, the automatic collected statistics utility collects statistics only for tables that support efficient sampling.
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 supporting efficient sampling only. to ignore the requirement that the automatic collected statistics utility tables support efficient sampling (that is, change the value to 0).
You can also change AutoStatsForEfficientSamplingTableOnly by editing the CPF in a text editor (as described in Editing the Active CPF).
