Is there any benefit to using one of these over the other?
-
AND (r.resolve_status = 0 OR ISNULL(r.resolve_status))
-
AND r.resolve_status IN(0,NULL)
I ran a query through an online “tuner” and the only recommendation was to use IN instead of OR. I can not find any documentation on this, but then again searching for variations of ‘using or or in’ may not have been the best approach.