Oracle 性能 IN 或 OR
oracle 中哪个操作符能提供更好的性能 IN 或 OR
Which operator in oracle gives better performance IN or OR
例如:
select * from table where y in (1,2,3)
或
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.
相关文章