--- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > - How many rows does your query return ? If it's a > huge number I would > feel more comfortable with table scans than index > accesses in the plan.
It returns 8 rows in about 2-2.5 seconds. > - You seem to feed three things into your query, > racf (any > relationship to the IBM product?), product (your > query doesn't say from > which table it comes) and the date (BTW implicit > conversions like here > always make me feel nervous). Which one is the most > selective ? Try to > have your query start with the corresponding table > (I am a big fan of > /*+ ORDERED */). I did something like that. I have prevented Oracle from using the index STATS_FK2 (on a manager field) by comcatinating ||'' to the manager field name. It forced Oracle to use the index on the date field (more selective) and reduced the time to 0.5 sec and I think increased the bhr to 95%. Thanks for your help Gene __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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).
