Archives of the TeradataForum

Message Posted: Tue, 01 Feb 2005 @ 16:20:14 GMT

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

In teradata documents they do mention that we can have max of 512 valuesin in-list ..Again it depends how you are connecting thru ODBC or JDBC ..In our application we saw JDBC exceptions when we pass more values in the in-list clause . The good fix for this kind of issues is to create a volatile table and then do a INNER JOIN instead of using large in-list

In V2R6 they improved the in-list Access path (InListAxp)

Hope this helps

Thanks,

Srini

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