To enable CBO for
, set the
initialization parameter to RULE and collect statistics for the USTs. The existing applications continue to use RBO, and when
accesses the USTs,
specifies the CHOOSE hint. The CHOOSE hint causes the optimizer to choose between RBO and CBO based on the presence of statistics. If statistics exist for any of the USTs,
uses the CBO.