QSM-01002 no query rewrite when OPTIMIZER_GOAL is rule basedCause: Query rewrite will not occur when OPTIMIZER_GOAL is set to rule based.Action: Change optimizer goal with ALTER SESSION SET OPTIMIZER_GOAL = "goal" command, where goal can be one of "CHOOSE", "FIRST_ROWS" or "ALL_ROWS".
试试
hippie1024(痞子)
我已经写上了这句话
ALTER SESSION SET OPTIMIZER_GOAL=CHOOSE;
还是不行。
依然提示:Query rewrite will not occur when OPTIMIZER_GOAL is set to rule based
ALTER DATABASE SET OPTIMIZER_GOAL=CHOOSE;
ALTER SESSION SET OPTIMIZER_GOAL=FIRST_ROWS
alter session set query_rewrite_enabled=true