Archives of the TeradataForum

Message Posted: Wed, 18 Feb 2004 @ 22:37:22 GMT

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

We often coded this expression with other inner join indexed criteria in V2R4 to trick the machine to avoid a product join and a spool space problem for a small table, large table join. If it is the only join criteria then it will result in a cross join.

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