ALTER SESSION SET optimizer_mode = FIRST_ROWS_10 / ALTER SESSION SET "_HASH_JOIN_ENABLED" = FALSE / ALTER SESSION SET "_OPTIMIZER_SORTMERGE_JOIN_ENABLED" = FALSE / ALTER SESSION SET "_OPTIMIZER_JOIN_SEL_SANITY_CHECK" = TRUE /
相同的SQL,SIEBEL中跑和直接在plsql中跑,出来的执行计划可能会不一样。
执行上面的语句后,两者的执行计划就会一样了