Name
OPTIMIZER_MODE
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.