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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cost is higher but query is much faster

Re: Cost is higher but query is much faster

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 28 Mar 2002 06:58:04 -0000
Message-ID: <1017298646.10137.1.nnrp-13.9e984b29@news.demon.co.uk>

It's another one for Rob Freeman to add
to his "Favourite Urban Legends".

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

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


Connor McDonald wrote in message <3CA240A9.23E3_at_yahoo.com>...

>Alan wrote:
>>
>> Also, remember that the best CBO query will never perform any faster than
an
>> optimally constructed RBO query.
>>
>
>Would you care to justify that remark?
>
>I'm dying to see how the RBO is going to handle a function based index..
>
>Cheers
>Connor
Received on Thu Mar 28 2002 - 00:58:04 CST

Original text of this message

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