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
- 8127 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 is the main difference between constraints(like primary key etc..)& joins?
When multiple after triggers are attached to sql table, how to control the order of execution?
what is the order of execution of where,having,group by in select stement
6 Answers IBM, Tanla Solutions,
Explain what is row_number function?
What is the difference between IN and EXISTS operators in SQL Server?
9 Answers ASD Lab, CSC, Intelligroup,
Explain the properties of sub-query in sql server?
What do you understand by recursive stored procedures?
What is the difference between clustered index and primary key?
Which one is faster delete/truncate? Why?
What is bulkcopy in sql?
How are SQL Server databases physically stored under Windows 2000?
what command is used to create a table by copying the structure of another table?
-
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)
