Set query optimization to biased toward outliers.
When BiasQueriesAsOutlier is enabled (n = 1), InterSystems SQL optimizes for queries that primarily return outlier values. For further details on outlier selectivity, refer to Tune Table in the “Optimizing Tables” chapter in InterSystems SQL Optimization Guide.
BiasQueriesAsOutlier and RTPC cannot both be active at the same time. If both BiasQueriesAsOutlier and RTPC are set to 1, RTPC is activated and the BiasQueriesAsOutlier setting is ignored. When RTPC is set, InterSystems SQL determines whether to use outlier optimization on a per-query basis.
If AdaptiveMode is enabled (set to 1) and BiasQueriesAsOutlier is active and enabled, then Adaptive Mode overrides the BiasQueriesAsOutlier setting and disables outlier bias.
Adaptive Mode replaces the earlier BiasQueriesAsOutlier mechanism. Please contact the WRC is you were previously using this setting and need assistance.