| 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 performance | Oscar | 29 Mar |
| • Re: IN vs. OR on performance | Ian P. Christian | 29 Mar |
| • RE: IN vs. OR on performance | Martin Gainty | 29 Mar |
| • Re: IN vs. OR on performance | Claudio Nanni | 29 Mar |
| • Re: IN vs. OR on performance | Baron Schwartz | 31 Mar |
