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
- 7288 Views
- Cognizant, HCL, Value Labs, I also Faced
- E-Mail Answers
Answer / 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 |
What does the on update no action do?
Explain the properties of sub-query in sql server?
what are user defined datatypes? : Sql server database administration
What is a stored procedure?
What is the difference between commit and rollback?
Mention the differences between sql server and mysql.
Can you pass expressions to stored procedure parameters?
Can another user execute your local temporary stored procedures?
What is Inner Join?
What is order of B+tree?
What do you mean by a Composite primary key?
When is update_statistics command used?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
