>No, you do need to use parameterized approach. However, you may be running in parameters sniffing problem. If that's the case, addition OPTION (RECOMPILE) to the end of the query may fix the problem.

So, SQL Server performs less with the parameterized approach. We just saw that in the new execution plan it would give. What do you recommand to keep the parameterized approach and keep the benefit of the optimized execution plan?