Is there any performance difference between a SQL "IN" statement versus using "OR"?
- by Mark Kadlec
Thought I would ask the knowledgeable StackOverflow community a question that was on my mind today and I can't seem to find an answer.
Is there any performance difference or advantage between an "IN" or using "OR"?
Ie. Is
SELECT type FROM types WHERE typecat IN ('abc', 'def')
better than
SELECT type FROM types WHERE typecat = 'abc' OR typecat = 'def'