Oracle CBO question
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jun 2007 07:53:40 -0400
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?
- Follow-Ups:
- Re: Oracle CBO question
- From: Alex Gorbachev
- Re: Oracle CBO question
- From: Arul Ramachandran
- Re: Oracle CBO question
- From: Jared Still
- References:
- Varying plans on different nodes
- From: fairlie rego
Other related posts:
- » Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- Re: Oracle CBO question
- From: Alex Gorbachev
- Re: Oracle CBO question
- From: Arul Ramachandran
- Re: Oracle CBO question
- From: Jared Still
- Varying plans on different nodes
- From: fairlie rego