Re: Function Based Index - Not Used ???

Thanks Tim.

But the SELECT returns just 2 of 20,00,000 records. and the Time elapsed for Index scan is 0.7 secs where as it is 5 secs for FTS.

Hell a lot of lousy things here Tim.
just mending it one by one.

Regards,
Jp.

2003/05/29 22:30:02, Tim Gorman <tim_at_sagelogix.com> wrote:
>JP,
>In the EXPLAIN PLAN, it says "Card=262146", indicating that the query
>expects to retrieve over a quarter-million rows. Is that in fact correct?
>If so, the CBO is making the correct decision to perform a FULL table scan.
>What was the comparison of elapsed times between the two plans, the one
>being the FULL table scan and the other being the indexed scan? I bet the
>FULL table scan query finished much more quickly...
>You've got everything configured correctly -- simply a lousy index. The CBO
>has to be coerced into using the index because it is not the best plan to
>use.
>Hope this helps...
>-Tim

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).