ALTER SESSION SET optimizer_index_cost_adj = 2;
EXPLAIN PLAN FOR
SELECT sum(T130409.PAX_INCOME) as c1,
T128508.ADMIN_AREA as c2
from
DIM_SEG_TYPE T128582,
EXPLAIN PLAN FOR
SELECT sum(T130409.PAX_INCOME) as c1,
T128508.ADMIN_AREA as c2
from
DIM_SEG_TYPE T128582,
DIM_AGENT T128508
......
SELECT * from TABLE(dbms_xplan.display)
通过此可以查看此sql的执行计划
ALTER SESSION SET optimizer_index_cost_adj = 2; 设置索引的重要度
类似的还有ALTER SESSION SET optimizer_features_enable = '8.1.7'; 设置优化器使用的版本。
上面是会话级的操作,还有通过hint方式的。