-
re: puzzling performance of query
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) ..
thanks,
harish
thanks,
harish
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|