Message Oracle QSM-01002 - no query rewrite when OPTIMIZER_MODE is rule based

ERRORno query rewrite when OPTIMIZER_MODE is rule based
CAUSEQuery rewrite did not occur because the OPTIMIZER_MODE was set to RULE.
ACTIONChange the optimizer mode using the OPTIMIZER_MODE parameter.