n is either 1 or 0. The default value is 0.
When RTPC is enabled (n = 1), InterSystems SQL queries can perform optimization based on outlier information. For further details on outlier selectivity, refer to Tune Table in the “Optimizing Tables” chapter in InterSystems SQL Optimization Guide.
RTPC cannot be set to 1 if the BiasQueriesAsOutlier parameter is also set to 1. When BiasQueriesAsOutlier is set, InterSystems SQL is optimized for queries that often refer to the outlier.
Changing This Parameter
On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), for the Optimize queries based on parameter values setting, choose Optimize for actual query parameter values at runtime.
To set the desired value for RTPC from the Terminal, use the SetOption(“RTPC”)Opens in a new window method of the %SYSTEM.SQL.UtilOpens in a new window class. See the class reference for details.
You can also change RTPC with the Config.SQLOpens in a new window class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).