Skip to main content

BiasQueriesAsOutlier

Set query optimization to biased toward outliers.

Synopsis

[SQL]    BiasQueriesAsOutlier=n

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

Description

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.

Changing This Parameter

You can change BiasQueriesAsOutlier with the Config.SQL 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).

Feedback