GeekInterview.com
Series: Subject: Topic:
Question: 4 of 291

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
Asked by: srividhya_85 | Member Since Jun-2008 | Asked on: Jun 24th, 2012

View all questions by srividhya_85   View all answers by srividhya_85

Showing Answers 1 - 2 of 2 Answers
Avi

Answered On : Sep 25th, 2012

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

  
Login to rate this answer.
shams756

Answered On : Nov 2nd, 2012

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

  
Login to rate this answer.

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

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Database Administration

Interview Coaching

What do you think about our company?

Have you gone above and beyond your job description?

Do you seek advice from others when you have a question?

What do you think about continuous learning?

Describe a time when you had to listen to someone.

What is the role of a mechanical engineer in the Software Industry?

Has anyone asked you for help? What did you do?

Do you like working in a team or alone? Explain.

How do you deal and overcome major challenges?

Describe a time when you had to work under pressure.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle DBA FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe