Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO calculates lower cost, but runs slower...

Re: CBO calculates lower cost, but runs slower...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 20 Nov 2001 13:41:19 -0000
Message-ID: <1006263587.27925.0.nnrp-13.9e984b29@news.demon.co.uk>

Comments embedded

--
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.

Nuno Souto wrote in message <3bfa3b0d.10357437_at_news>...

>Sorry if I sounded pedantic, but:
There is an important distinction between pedantry and precision - many of the errors and misunderstandings regarding Oracle database activity are due to lack of precision, in particular fully qualified statements. I stand duly corrected.
>
>I've had quite a few tell me that "plans with higher costs cannot
>possibly execute faster". No qualification of the statement
>whatsoever. Oh well...
>
Another list for the FAQ, perhaps - top 10 (20, 100) reasons where a plan with a higher cost can run faster than a plan with a lower cost.
Received on Tue Nov 20 2001 - 07:41:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US