Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Optimizer Mode......how to choose the right one?
Hi Steven,
it depends on what optimizer will actually
work with your particular statement.
Yes for RBO (in fact, in some
cases)
No for CBO (except 'hard' cases when default
number of permutations (80.000) is not enough)
Regards,
Ed
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<FONT
face="ARIAL CYR">
Does the order of tables also make a
difference with a RULE hint?
Steven HaasOpus Consultants, LLC
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><FONT
face="Arial Cyr" size=2>
Received on Thu Aug 09 2001 - 19:43:36 CDT
![]() |
![]() |