>>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.
If it's not broken, fix it until it is.
My Blog