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
- 7591 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 thr feature of change data capture?
What are the different ways you can create databases in sql server?
What do you mean by normalisation?
Explain data warehousing in sql server?
what is statistics
what is raid and what are different types of raid configurations? : Sql server database administration
How to add a new dsn with the odbc driver for sql server?
what is a transaction? : Sql server database administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What are the differences between DDL, DML and DCL in SQL?
0 Answers ABB, Aspire, Infogain,
Explain atomicity?
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
