Archives of the TeradataForum
Message Posted: Wed, 30 May 2012 @ 09:54:08 GMT
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 ?
Sel * from EMPLOYEE where EMP_No IN (1,2,3,4,5,6............12345);
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|