Replacing Dynamic SQL for Performance Improvement

Murugesh P

Murugesh P

Dec 2 2014 4:04 AM
Hi All,

I have a condition where data will be pulled from Table based on some where conditions. But Where conditions are dynamic in this case.
E.G It will be Where Name = 'Ram' one time and Age = 10 another time. Combinations are also allowed.
I have achieved this using Dynamic SQL (Appending Where condition based on search criteria). Now i need to Tune the query for performance. Can anyone suggest a way to improve the performance?

Answers (1)