Efficiency question in 'WHERE' clause

blmgyossi · #1 (**permalink**) 11-08-06, 12:22

would it be more efficient to do

WHERE a = 'b' OR a = 'c' OR a = 'd'

or

WHERE a IN ('b','c','d')?

healdem · #2 (**permalink**) 11-08-06, 13:04

try it and see

I'd guess there will be little or no difference, it wouldn't surprise me if the optimiser resolved both constructs in the same manner

r937 · #3 (**permalink**) 11-08-06, 14:19

depends

are you referring to computer efficiency or programmer efficiency?

if the former, it's a wash

if the latter, the IN list is definitely favoured