I'm puzzled by the following paragraph in Tuning Guide->DML statements
and performance->Performance and optimization->Joins and
performance->Join strategies:
"If memory use is not a problem for your environment, set this property
to a high number; allowing the optimizer the maximum flexibility in
considering a join strategy queries involving large queries leads to
better performance. It can also be set to smaller values for more
limited environments."
I can't find the name of this property on that page of the Tuning Guide.
I'm also confused about what we consider to be a "high number" versus
what we consider to be "smaller values". Would appreciate advice here.
Thanks,
-Rick
- optimizer documentation Rick Hillegas
-