December 2002
Intermediate to advanced
928 pages
85h 29m
English
OPTIMIZER_MAX_PERMUTATIONS
Value: 0-100
Default: 100
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies the maximum number of permutations of the tables that the optimizer will consider in queries with joins. If this parameter is too low, parse times for queries will be reduced at the added risk of overlooking a better execution plan. A value of 80,000 means no limit.