Vladimir Basanovic (5/20/2010)
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
Is it Vladmir... 😎
Thanks for sharing the idea. I know it is very simple thing but not aware.
Although I use to write WHERE clause using COALESCE, but do not know the performance improvement.
Really appriciate.