Answers

Question and Answer:

  Home  SQL Server DB Administrator

⟩ What are the steps to take to improve performance of a poor performing query?

► 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.

 154 views

More Questions for you: