Peformance of IN vs. OR

1	From a performance perspective what is the better approach for huge tables: using OR or using IN like in select * from table where a = 1 or a = 2; vs. select * from table where a in (1,2) performance optimizer sql asked 30 Oct '12, 07:15 Martin 9.0k●130●169●257 accept rate: 14% flat view

2 Answers:

AFAIK, they are semantically equivalent and should be rewritten in the same way.

Cf. page 10 from this excellent whitepaper by Ani:

permanent link

answered 30 Oct '12, 07:25

Volker Barth
40.2k●361●550●822
accept rate: 34%

I thought so too (equivalent) anyway in real world I see totally different plans which are used...

Thanks for the link, I wasn't aware of this paper!

(30 Oct '12, 07:28) Martin

Replies hidden

Well, I'd just noticed it today and really like to share that link:)

(30 Oct '12, 07:47) Volker Barth

flat view

-2	Can't say for sure in SQL Anywhere database, but you can check this link for a general behavior. permanent link answered 01 Nov '12, 07:47 Gandalf 199●5●7●16 accept rate: 50% flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 30 Oct '12, 07:15

question was seen: 2,282 times

last updated: 01 Nov '12, 07:47

SAP SQL Anywhere