WHERE clause OR vs IN - Mailing list pgsql-admin

From Medi Montaseri
Subject WHERE clause OR vs IN
Date
Msg-id 8078a1730712121425u51dca445j6f8f75468cdeda40@mail.gmail.com
Whole thread Raw
Responses Re: WHERE clause OR vs IN  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Hi,

I know this is not exactly admin related, but ... it is simple enough to be even fun

From a performance point of view, is it better to use OR as in
SELECT expr FROM expr WHERE col=this OR col=that OR col=theOther
Or to use a range of values as in
SELECT expr FROM expr WHERE col in ( val1, val2, ...., valn)

I think the IN range yields a better query plan .... what do you think ?
Thanks
Medi

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Re: Legacy foreign keys
Next
From: "Joshua D. Drake"
Date:
Subject: Re: WHERE clause OR vs IN