SQL Performance (MOSC)

MOSC Banner

query speed need to increase in non prod ..same query is good in prod.

edited Aug 2, 2013 12:40AM in SQL Performance (MOSC) 7 commentsAnswered
How to increase the query speed in non prod?


Below is the plan output.The select query is taking 50 minutes in prod but same query taking more than 3 minutes on non prod.

1.compared prod and non prod database parameters<--they are sync.
2.stats are upto date in non prod? <--yes
3.Plan output is same in prod and non prod? <--yes below plan is same.
4.table got fragmented<--no
5.indexes are rebuild <--yes

6.No changes were done in database and also application code<--yes

question:what else more I need to focus to boost the perfomance of query in non prod.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center