Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 13:55:22 GMT

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

Rohit:

Since you didn't specify and the fact you are running out of SPOOL, I am guessing that you are doing a UNION instead of a UNION ALL. By default, UNION eliminates duplicates. My estimation is that the redistribution necessary to eliminate dups is sending so many rows to one AMP that you are running out of space.

If there should never be duplicates, use UNION ALL. The side benefit is that it will be faster because of the elimination of an unnecessary execution step.

Hope this helps,

Michael Larkins
Certified Teradata Master

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