Interested to Buy Any Domain ? << Click Here >> for more details...
Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
- 1 Answers
- 3244 Views
- I also Faced
- E-Mail Answers
Answer / neetu
U have to optimize SP for that
1. Use as much as possible WHERE clause filters. Where
Clause is the most important part for optimization
2. Select only those fields which really require.
3. Joins are expensive in terms of time. Make sure that use
all the keys that relate the two tables together and don't
join to unused tables, always try to join on indexed fields.
The join type is important as well (INNER, OUTER).
| Is This Answer Correct ? | 3 Yes | 0 No |
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Difference between rowid and rownum in SQL?
Define a cross join?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to execute the cursor queries with "open" statements?
How to select some specific rows from a table in ms sql server?
What is outer join in sql server joins?
How can you insert null values in a column while inserting the data?
What are the different subsets of sql?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are the five major components of a dbms?
-
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)
