Given that the output was clearly from autotrace,
and the lines in the execution path had no 'cost'
or 'card' elements, even though several tables
were listed, I would say that the original assumption
was a perfectly reasonable one to make.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Niall Litchfield wrote in message
<3bcc0262$0$227$ed9e5944_at_reading.news.pipex.net>...
><sweidanz_at_yahoo.com> wrote in message
>news:Zryx7.10$cH1.347_at_nsw.nnrp.telstra.net...
>> Can you please explain how you read it that way and how you knew its
>> cost-based method? If the optimiser is CHOOSE it does not mean Oracle is
>> going use the cost-based!! If none of the tables in the query is
analyzed,
>> oracle is going use the rule-based. right?
>
>Of course you are right. If no stats exist then Oracle has to use the rule
>based optimiser.So I should have said that stats might be "out of
>date,innaccurate or non-existent". My real gripe was with the statement "I
>see you are using RULE. " You could only state this for sure if the explain
>plan said Optimizer=RULE. Any other value says that Oracle will use the CBO
>if at all possible.
Received on Tue Oct 16 2001 - 13:07:40 CDT
