List:General Discussion« Previous MessageNext Message »
From:Oscar Date:March 29 2009 5:33am
Subject:IN vs. OR on performance
View as plain text  
Hi all-

I want to know what the difference between IN and OR is under the hood.

select * from dummy_table where id in (2, 3, 4, 5, 6, 7);

select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
id=7;

I run the query sql on the test schema, it seems that there is no
performance difference between these two pieces of sql.

Thank you,

-Oscar

Thread
IN vs. OR on performanceOscar29 Mar
  • Re: IN vs. OR on performanceIan P. Christian29 Mar
    • RE: IN vs. OR on performanceMartin Gainty29 Mar
    • Re: IN vs. OR on performanceClaudio Nanni29 Mar
      • Re: IN vs. OR on performanceBaron Schwartz31 Mar