1.

What Are The Steps To Take To Improve Performance Of A Poor Performing Query?

Answer»
  •  Maximum use of INDEXES, STORED procures should be DONE.
  •  Avoid excessive use of complicated joins and cursors.
  •  Avoid using CONDITIONAL operators using COLUMNS of different tables.
  •  Make use of computed columns and rewriting the query.


Discussion

No Comment Found

Related InterviewSolutions