Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2003 @ 14:44:52 GMT

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

As a ROT I would say the 1st two are definitely doing extended "product joins" (or INSERT with high duplicate row checking); although I don't know your # of AMPs. The next three may have had product join step(s) in the explain but the steps completed in a few minutes.

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