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
- 3322 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 |
What is data integrity? Explain constraints?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is indexing and its types?
What is sub query and its properties?
Is sql server a database?
Indexes are updated automatically is the full-text index also updated automatically?
what is web server?
How to get all stored procedures in sql server?
what's the difference between delete table and truncate table commands? : Sql server database administration
Give an example of why you would want to denormalize a database
What is the default sql server instance name?
What stored procedure would you use to view lock information?
-
Oracle (3253) - 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)
