Re: Oracle CBO question
- From: "Arul Ramachandran" <contactarul@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Thu, 7 Jun 2007 06:53:09 -0700
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@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?
--
Arul
Other related posts:
