IN Clause | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

IN Clause

What is the maximum amount of items an IN clause can evaluate? Joe Janka
Im not aware of any limit…given that you can do something like:
WHERE field IN (SELECT Field2 FROM Table1), wouldnt the size of the IN list be unlimited?
Even I dont think there is any limitations to using IN keyword.
While I’m not aware of any explicite limitation here, consider this:;EN-US;843534;EN-US;815183 Also, large IN clauses tend to slow down things —