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
Received on Thu Jun 07 2007 - 07:56:29 CDT
