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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
