From a performance perspective what is the better approach for huge tables:
using OR or using IN like in
select * from table where a = 1 or a = 2; vs. select * from table where a in (1,2)
asked 30 Oct '12, 07:15
AFAIK, they are semantically equivalent and should be rewritten in the same way.
Cf. page 10 from this excellent whitepaper by Ani:
Query Processing Based on SQL Anywhere 12.0.1 Architecture, as referenced in this doc page.
answered 30 Oct '12, 07:25