Where clause efficiency using "IN"

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Where clause efficiency using "IN"
Date: 2004-10-22 15:07:45
Message-ID: 20C3B01D-243C-11D9-8BC9-000A95D7BA10@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Just a quick general question: Can someone comment on using where
clauses like:

(sample = 2 OR sample = 3 OR sample = 4)

as compared to

sample in (2,3,4)

in terms of efficiency?

Thanks,
Sean

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Scott Marlowe 2004-10-22 15:42:16 Re: Where clause efficiency using "IN"
Previous Message Davide Negri 2004-10-22 13:52:36 Log