1.

What Are The Steps To Improve The Performance Of A Query?

Answer»

● Number of joins and use of complex views/cursors have to be reduced.
● The use of the stored procedures and INDEXES have to be maximized.
● The optimized use of the complex conditional CHECKS and computer columns have to be in place.
● TRACKING of performance analysis for the query helps us in identifying the right ASPECTS to optimize.

● Number of joins and use of complex views/cursors have to be reduced.
● The use of the stored procedures and indexes have to be maximized.
● The optimized use of the complex conditional checks and computer columns have to be in place.
● Tracking of performance analysis for the query helps us in identifying the right aspects to optimize.


Discussion

No Comment Found

Related InterviewSolutions