query speed need to increase in non prod ..same query is good in 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.