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
- 7976 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 are Row versions of DataRow?
What are key constraints?
Alternative way to DetDate() function?
How to run sql server 2005 books online on your local system?
what is Buffer cash and Log Cache? Can you Explain it?
how many no of arguments can be passed in procedures and functions
What are the characteristics of modern DBMS?
Can we add our custom code in ssis?
How to assign new column names in a view?
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
What do you mean by table and field in sql?
What are built in functions?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
