optimizer_mode参数值
Oracle 9i
RBO (Rule Based Optimizer) 基于规则
alter session set optimizer_mode = RULE;
CBO (Cost Based Optimizer) 基于成本
alter session set optimizer_mode = choose;
Oracle 10g开始rule和choose的设置时不可用的,只能使用如下的设置:
alter session set optimizer_mode = ALL_ROWS;
alter session set optimizer_mode = FIRST_ROWS;
alter session set optimizer_mode = FIRST_ROWS_100;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20666745/viewspace-630675/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20666745/viewspace-630675/