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: Oracle CBO question

Re: Oracle CBO question

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Thu, 7 Jun 2007 06:53:09 -0700
Message-ID: <1c1a62990706070653m123b6d60u64e1aca28a97bda9@mail.gmail.com>


I'd like to know where the consultant developer got this information :-)

This can't be true, I've been working on CRM application where most queries are at the very least 25 way joins. No special CBO settings done for them.

Arul

On 6/7/07, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com> wrote:
>
> I have received a question from a consultant developer below. Can
> anyone answer?
>
>
>
> I was once told that the CBO can only handle a certain number of tables in
> a query (16 iirc). Do you know what the CBO does when there are more? Try
> to optimize based on knowledge of the first 16 tables in the Where clause?
>
>
>
>
>

-- 
Arul

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 07 2007 - 08:53:09 CDT

Original text of this message

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