Oracle 性能 IN 或 OR

2021-12-24 00:00:00 sql oracle plsql

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.

相关文章