AutoStatsForRemoteGlobalTable
Determine whether the collected statistics utility should gather statistics for tables whose data is stored in globals that map to remote databases.
Synopsis
[SQL] AutoStatsForRemoteGlobalTable=n
n is either 0 or 1. The default value is 0.
Description
When AutoStatsForRemoteGlobalTable is enabled, the automatic collected statistics utility does not gather statistics for tables whose data is stored in globals that map to remote databases.
Changing This Parameter
On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Enable automatic statistics collection for tables whose default data global maps to remote databases. to .
You can also change AutoStatsForRemoteGlobalTable by editing the CPF in a text editor (as described in Editing the Active CPF).
