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
- 8128 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
What is the security principal at the database level that represents your session?
What is wide table?
Explain about system database?
How to set a database state to offline in ms sql server?
Explain what are sparse columns?
What are tables in sql server?
Can you name a few encryption mechanisms in sql server?
What is partition index in sql server?
What is the difference between Normalization and De-normalization?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to get the definition of a stored procedure back?
What is the difference between a fill factor of 100 and 0?
Explain the different types of joins?
How to execute function in stored procedure sql server?
Do you know what are various aggregate functions that are available?
