Re: RE: Function Based Index - Not Used ???

John,

I tried it with COMPATIBLE=8.1.6.
no nulls in that particular column
but it's the same again.

As Tim pointed out,
CARD=262146 --> as per the EXPLAIN PLAN for SELECT w/o HINT. the SELECT retuens about 2.5 million rows. which is why it goes for a FTS than a Index scan is my understanding correct ?

Thanks a lot John.

Jp.

2003/05/29 21:45:44, "Hallas, John, Tech Dev" <John.Hallas_at_gb.vodafone.co.uk> wrote:
>Naveen , these parameters look to be already set
>Doesn't FBI come in with 8.1.7 and Prem is on 8.16 and a comapatible of 8.10 is
in place
>Failing that, as my second guess, 2 privileges need to be assigned to the user
(QUERY_REWRITE and CREATE INDEX). The 2nd one is obviously in place to allow the index to be created but I don't know about the first
>The final point is whether the name column is not null , again I assume not but
it is a possibility
>John

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