fine tuning SQL SERVER stored procedure
- Implementing NOLOCK keyword
- Implementing the Clustered and Non Clustered index at appropriate places.
- Reducing the Joins and possibly avoid redundancy
- Study Execution Plan – Cost Estimate Calculation – Ensure individual operations taking less cost
- Avoid cursors and implement correlated sub query.
What are the ways of fine tuning the SQL SERVER procedure ? was last modified: October 1st, 2017 by