>>I am also not sure about your 1000 primary keys - why is it relevant?
>
>Because I prefer to use a 1k SQL command with 1000 OR conditions than to repeat the 1k line 1000 times with one condition.
>
>>In any case, you asked what can be used instead of OR and I gave you the answer.
>
>Yes, but it wouldn't apply here.

You don't need to use 1 condition per select. Split them in 2 equal parts.

There is no other magic bullet, I think, except for the case when all conditions are for the same column. In this case you would use IN subselect.