>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.

OK, thanks.

Well, all I can say is that to be the best of my awareness, anytime a WHERE clause has variables/parameters, you'll see those operators (unless you're using dynamic SQL to construct the entire query, which would be a different story)