RE: Oracle CBO question
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <gorbyx@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jun 2007 09:08:18 -0400
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@xxxxxxxxxxx
x72546
904 727-2546
-----Original Message-----
From: Alex Gorbachev [mailto:gorbyx@xxxxxxxxx]
Sent: Thursday, June 07, 2007 8:56 AM
To: Patterson, Joel; oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle CBO question
The answer is simlpe - ask him where he read this. ;-)
On 6/7/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
