Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 23:25:29 GMT

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

We have the same experience. Not sure why, not sure if it is a bug. Probably some internal limit is reached and the parser reverts to an all amp retrieve. Our policy in such cases is to build and load the values into a temporary table and modify the query by replacing the IN clause with a join to the temp table.

--Jason

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