Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Roberts Use Dynamic SQL to Improve Query Performance RE: Use Dynamic SQL to Improve Query Performance
Vladimir Basanovic
SSC Enthusiast
Points: 164
More actions
May 20, 2010 at 12:07 am
#1169872
Maybe you should consider rewriting original function with coalesce on every parameter. That's how you would avoid table scan if the parameter is null.
BR,
Vladimir