SQL Server Performance Forum – Threads Archive
IN Clause
What is the maximum amount of items an IN clause can evaluate? Joe JankaIm 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:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;843534
http://support.microsoft.com/default.aspx?scid=kb;EN-US;815183 Also, large IN clauses tend to slow down things —
Frank
http://www.insidesql.de
]]>