Querying data by multiple ids (large number)

Question

I want to query data for a set of IDs from a table. The size of the set might become large in some cases, for around 1000 to 4000 IDs.

Ex1: SELECT x FROM table WHERE id IN (ID1, ID2, ..., ID4000)

Ex2: SELECT x FROM table WHERE id = ID1 OR id = ID2 ... OR id =ID4000

1- Whats the limitation of including such a set in the query's WHERE clause (OR or IN statement)?

2- Is there a drawback or is that size considered large?

3- Is splitting the query to smaller portions the alternative?

The answer is implementation defined. Which dbms are you using? — jarlh, Oct 19 '17 at 11:40
Which [DBMS](https://en.wikipedia.org/wiki/DBMS) product are you using? Postgres? Oracle? "_SQL_" is just a query language, not the name of a specific database product. — , Oct 19 '17 at 11:50

score 0 · Answer 1 · answered Oct 19 '17 at 11:48

This link below will help you to think which is better to use.

Maybe, first of all, you should tell me what database you Are using.

1 Answers1