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
- 8006 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
Explain optimistic and pessimistic concurrency?
What are the differences between decimal and float in ms sql server?
What is implicit mode in sql server?
Explain about nested stored procedure?
Where can you find the error log information? : sql server database administration
How to insert multiple rows with one insert statement in ms sql server?
What is parameterized reports in ssrs ?
What is correlated subquery in sql server?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Can the query output be sorted by multiple columns in ms sql server?
What is a Join and explain its types?
How to set a database state to offline in ms sql server?
Which Model uses the SET concept
What is an index in a database?
What is sharding?
