Suppose i have one sql query that contains 2 minute to
execute.After one weekly i am executing same query that is
taking 5 minute.Why our same query is taking more time.what
would be my approach to reduce execution time.Please help.
- 1 Answers
- 7284 Views
- Cognizant, HCL, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
1.It might be index failure please see execution plan
2.DO update statistics for that table and check once again.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to define and use table alias names in ms sql server?
What is equi join with example?
How to add code to the existing article (using improve article)?
Write a sql query to display the current date?
In what three ways is the return statement used in a stored procedure?
What is model database? : SQL Server Architecture
What is factless fact table? : sql server analysis services, ssas
What is log cache in sql server?
what is normalization? : Sql server database administration
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the sql case statement used for? Explain with an example?
How to change parameter value inside the report?
Define Unique Key?
What does ss stand for sexually?
What is the osql utility?
