|
|
Archives of the TeradataForum
Message Posted: Wed, 30 May 2012 @ 09:54:08 GMT
Subj: | | Why a Query with Huge IN List Fails |
|
From: | | girish.nayak |
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);
| |