Performance Tuning

My query was running fine till last month. the query will run for each month end. suddenly it is taking more than 20 minutes for running. the data is increased by 1 million. the index are all working fine . There is no cpu utilization time and also no memory blocks. What may be the reason?The increase in data has happened previous months also

Questions by srividhya_85   answers by srividhya_85

Showing Answers 1 - 6 of 6 Answers

Avi

  • Sep 25th, 2012
 

check for the bottle necks starts from the source and continue till target

  Was this answer useful?  Yes

shams756

  • Nov 2nd, 2012
 

1) Try collecting Statistics
2) Spilt your query based on incoming unique values

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions