Erk.
The thought of joining 50,000 elements into an IN clause makes me shudder, possibly wrongly.
- I was always under the impression there was a limit to the number of items IN would allow, I'm pretty sure there was in DB2 V5, and though I haven't yet found the Oracle man page to back this up, I've avoided large IN's ever since.
- Not to mention the efficiency and the possible size of the SQL STATEMENT ......
NB I'm going away to do my homework on IN now...and validate / invalidate my long held assumptions...