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
- 3167 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how many types of relationship?
What are the filtered indexes?
What are the rendering extensions of ssrs?
What is difference between view and materialized view?
How many levels of sp nesting are possible?
What is the fastest way to permanently delete a 1 million row table named customers?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How many cores do I need for sql server 2016?
What is tempdb in sql server?
What are the different types of Indexes available in SQL Server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Define union, union all, minus, intersect?
Can multiple columns be used in sql group by clause in ms sql server?
What is a matrix in ssrs?
Explain intellisense for query editing
