December 2002
Intermediate to advanced
928 pages
85h 29m
English
OPTIMIZER_MODE
Value: RULE | CHOOSE | FIRST_ROWS_{1 | 10 | 100 | 1000} | FIRST_ROWS | ALL_ROWS
Default: CHOOSE
Dynamic: ALTER SESSION
Specifies the behavior of the optimizer. See Chapter 7 for an explanation of these values. Cost-based optimization will always be used for any query that references an object with a nonzero degree of parallelism.