• What you mention about choosing the best execution plan, is covered on Gail's article.

    And no, it won't give you better performance as it will use a "safe plan".

    You might not believe this, and the best thing to do, instead of guessing is to test.

    However, as you mention you need NULL values, then my option would be a dynamic query. As most things regarding SQL Server, the best solution would depend on the situation.;-)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2