Grant Fritchey - Thursday, December 14, 2017 5:02 AM
+ 1
They key data in our database involves a very similar type of condition. I did a comparison and ultimately landed on the solution Grant calls out. Far fewer table scans. Overall, much better query plan.