Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8147 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 delete an existing row with delete statements in ms sql server?
How to find tables without indexes?
What is code near application topology?
What is the maximum length of an alert name?
How to execute stored procedure and set temp table in sql server?
How network traffic be reduced by using the stored procedure?
What methods do you follow to protect from sql injection attack?
How to convert numeric expression data types by assignment operations?
what are the core components of SSRS?
What is inline variable assignment?
explain declarative management framework (dmf) in sql server 2008?
How to store and query spatial data?
Explain hostprotectionattribute in sql server 2005?
Explain what is the difference between a local and a global temporary table?
Can you explain what are various ways to enhance the ssrs report?
