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
- 8148 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 |
List out the differences between the clustered index and non-clustered index in sql server?
Which are ddl commands?
Explain user defined functions?
How to locate and take substrings with charindex() and substring() functions?
how to find out the repeated value from table using groupby function?
What is sql profiler. What are the default templates with it? : sql server database administration
How to search for a string in all stored procedure in sql server?
Describe in brief sql server monitoring ways.
What are the restraints imposed on the table design by a merge replication?
Explain the difference between HTTP and HTTPS in database?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
Normalization and denormalization
-
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)
