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