Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


Enable/disable query optimization biased toward outliers.


[SQL]    BiasQueriesAsOutlier=n


The value n may be 1 or 0:

  • When 1 (true), InterSystems SQL optimizes for queries that primarily return outlier values.

  • When 0 (false), it does not.



Range of Values

0 or 1. The default is 0.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Bias queries as outlier setting, choose choose Yes (true) or No (false).