Which operator in oracle gives better performance IN or OR
ex:
select * from table where y in (1,2,3)
or
select * from table where y = 1 or y = 2 or y = 3
You'd want to do an explain plan to be sure, but I would expect the performance to be identical.
2.1m questions
2.1m answers
60 comments
57.0k users