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
- 7250 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 |
Explain database normalization?
Explain how dts is used to extract, transform and consolidate data?
How do we know if any query is retrieving a large amount of data or very little data?
How to create a store procedure with encryption?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How many partitions a clustered index has by default in sql server 2012?
What are the steps you will take to improve performance of a poor performing query?
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
how to find 6th highest salary
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Explain about link server in sql server?
Why use identity in sql server?
-
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)
