• If speed isn't a issue here, I doubt it'd be worth it. I imagine there's easier ways to get bigger improvements too.

    Best bet would be to test for each case and see!

    Are you using OPTION (RECOMPILE) in your select? I've seen it have pretty dramatic effects on this type of query.

    Cheers