How do you optimize stored procedures in SQL Server 2005

 Posted by Neeks on 2/22/2009 | Category: Sql Server Interview questions | Views: 6853

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response