SQL Server: How Local Variables Can Reduce Query Performance

added by lionofdezert
7/20/2012 1:07:31 PM

2 Kicks, 262 Views

It’s a common practice by database developers to use local variables in stored procedures and scripts to place filter on basis of these local variables. YES, these local variables can slowdown your queries. How ???


1 comments

dpeterson
7/23/2012 9:11:51 AM
I'm going to agree with the comment on the article and chalk this up to the index and the columns that you are selecting, rather than just because of a variable.