Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cost is higher but query is much faster
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>...Received on Thu Mar 28 2002 - 00:58:04 CST
>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