>Michel, if you're getting the same performance and the same usage of the index, and the only difference is a paired set of compute scalar/constant scans for each variable in the execution plan, then I can say with confidence that the difference is insignificant.
>
>Again, when you use variables instead of literals in the WHERE clause (and I'm not even talking about parameters, just plain variables), SQL Server has to take an extra tiny step to evaluate the variables and then create an internal "constant row".
>
>The execution plan might really "look wonky" compared to using literals, especially if you have many variables - but because the total cost of all those additional operators is so small relative to the entire query cost, it's nothing to be concerned about. It's simply the way SQL Server works.
Thanks, but a lot of times, the execution plan does not show those scalar/constant scans. This is why I started to investigate as I found that weird that I suddenly observed that.