Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: Oracle CBO question

Arul Ramachandran

2007-06-07

Replies:

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@crowley.com <Joel.Patterson@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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.