hi! ,

I have a query that is taking 14-15 seconds to complete in prod onsite..

Its taking for ever to run about 45 minutes in a similar environment
simulated at our site ..

When I look at the explain plans they look exactly the same
except for the order of the indexes ...!!!

Could that be the problem for the poor performance at our site ?

Any ideas , hints , help would be appreciated ...!!!

i did the following on our site
execute dbms_stats.gather_schema_stats('schema_name) ..