re: puzzling performance of query
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) ..