Metalink 66484.1
注意:
(1) Hints in view definitions or in the SELECT clause of an INSERT or
CREATE TABLE are included for the flowchart.
(2) Recursive SQL choose the goal base on the instance setting.
This includes SQL called from PL/SQL. Of course hints
can be used in any SQL called by PL/SQL to override this default.
Instance Recursive
-------------------- --------------
RULE RULE
FIRST_ROWS CHOOSE
ALL_ROWS CHOOSE
CHOOSE CHOOSE
(3) If any table in a query has a parallel degreee greater than one
(including the default degree), Oracle uses the cost-based optimizer
for that query--even if OPTIMIZER_MODE = RULE, or if there is a RULE
hint in the query itself
(4) In general, be wary of the prescence of any new features as they are
likely to require the use of the Cost Based Optimizer.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/266281/viewspace-495481/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/266281/viewspace-495481/