Which query is good - IN or OR
Started by AI Rummanover 15 years ago2 messagesgeneral
A simple query I can write in any of the following two ways:
1.
Select col1
from table
where col2 in ('A','B');
2.
Select col1
from table
where
col2 = 'A'
or col2 = 'B'
Here IN condition may be more than two.
I need to know which one is good for good performance.
Any idea please.
Re: Which query is good - IN or OR
Hello
2010/12/9 AI Rumman <rummandba@gmail.com>:
A simple query I can write in any of the following two ways:
1.
Select col1
from table
where col2 in ('A','B');
2.
Select col1
from table
where
col2 = 'A'
or col2 = 'B'
Here IN condition may be more than two.
I need to know which one is good for good performance.
Any idea please.
It depends on real use case. In almost all cases these queries are almost same.
Regards
Pavel Stehule