Archives of the TeradataForum

Message Posted: Wed, 30 May 2012 @ 09:54:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Experts,

While browsing though the TD 13 Mannuals, i came to know that "Queries With Large [NOT] IN Clauses Fail". But found, the reason mentioned no where. Can any one pass on his/her experience

I am sure the limit for IN List has been taken out in TD 12 onwards.. but still needs the cause of above failure...

And is a huge IN List causes any performance impact ?

Ex:

     Sel * from EMPLOYEE where EMP_No IN (1,2,3,4,5,6............12345);

	<Prev	Next>		<<First	<Prev	Next>	Last>>