Archives of the TeradataForum

Message Posted: Fri, 05 Nov 2004 @ 13:40:48 GMT

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

We have had occasions in the past where if the users try to submit an IN clause with a lot of values (don't have a definite size), the query will drop the whole WHERE clause and end up with a Cartesian Join. This will cause the query to run a long time and usually run out of spool.

Like already suggested we tell them to use a subquery, derived table, or temp table to eliminate the IN list.

Bill H

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