RE: Oracle CBO question

Thanks, I'm fairly sure he doesn't remember... but just wants clarification. He works offsite, so I'd like to just be able to respond.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

-----Original Message-----
From: Alex Gorbachev [mailto:gorbyx_at_gmail.com] Sent: Thursday, June 07, 2007 8:56 AM
To: Patterson, Joel; oracle-l_at_freelists.org Subject: Re: Oracle CBO question

The answer is simlpe - ask him where he read this. ;-)

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?
>
>
>
>
>
>

-- 
Best regards,
Alex Gorbachev

http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l