Describe how you can optimize stored procedures in SQL Server?

 Posted by Tripati_tutu on 10/20/2010 | Category: Sql Server Interview questions | Views: 2898 | Points: 40

Below are some points to optimize stored procedure in SQL Server

• Use as much as possible WHERE clause filters. Where Clause is the most important part for optimization.

• Select only those fields which really required.

• Joins are expensive in terms of time. Make sure that use all the keys that relate to the tables together and don't join to the unused tables, always try to join on indexed fields. The join type is important as well in (INNER, OUTER).

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response