SQL Server: How Local Variables Can Reduce Query Performance

[ERR!]
added by lionofdezert
7/20/2012 1:07:31 PM

341 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 ???

Read the full story
mssql
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.