Regarding the second item, the optimizer is smart enough to know what to look for so that it won't check unnecessary items. I believe that you may get a different plan if you use 2 UNION statements instead of the OR conditions.