Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Optimizer Mode......how to choose the right one?

Re: Optimizer Mode......how to choose the right one?

From: Shevtsov, Eduard <EShevtsov_at_flagship.ru>
Date: Thu, 09 Aug 2001 17:43:36 -0700
Message-ID: <F001.0036646F.20010809133346@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US