opc.three (2/14/2013)
Any idea why this would happen or how to troubleshoot this?
No way to tell from here. Please post the Actual Execution Plans for all three queries.
I'll pull that and post it. Regardless, i was trying to understand why this would happen. I can tell you that the execution plan for the filter that works looks the same as the filter that doesn't work. The difference is in cost for the filter and nested loops