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
- 7972 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 similarity and difference between truncate and delete in sql?
What is it unwise to create wide clustered index keys?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How to view existing indexes on an given table using sys.indexes?
What is database white box testing?
Explain the properties of the relational tables?
How to start and end transact-sql statements?
What's new in sql management studio for sql server? : sql server management studio
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the difference between set and select?
Explain the advantages of merge replication?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to list all login names on the ms sql server?
What is the use of sign function?
