Re: Oracle CBO question
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 7 Jun 2007 08:56:29 -0400
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
Other related posts:
