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.
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 contrast between sql and mysql?
Explain the rules for designing files and file groups in sql server?
Can you type more than one query in the query editor screen at the same time?
Define indexes?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Explain active/passive and active/active cluster configurations?
What are orphan records?
What kind of problems occurs if we do not implement proper locking strategy?
What is the difference between a clustered index and a non-clustered index?
What is similarity and difference between truncate and delete in sql?
What is the difference between cartesian product and cross join?
What is implicit mode in sql server?
Explain differences between web edition and business edition?
Who is the owner of a schema in ms sql server?