Governs the extent to which the SQL for an application is to be optimized.
XOLAPENABLEHEURISTICS [appname] TRUE | FALSE
appname (optional)—Application name. If you do not specify an application, the setting (TRUE or FALSE) will apply to all XOLAP-enabled cubes.
TRUE—SQL optimization is performed based upon the number of members in the levels of an XOLAP-enabled cube.
FALSE—SQL optimization is not performed. FALSE is the default value.
The XOLAPENABLEHEURISTICS setting governs the extent to which the SQL for an application is to be optimized. The optimization is based upon the number of members in the levels of the XOLAP-enabled cube.
XXOLAPENABLEHEURISTICS my_app TRUE