Replacing Dynamic SQL for Performance Improvement
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?