Archives of the TeradataForum

Message Posted: Wed, 05 Jul 2006 @ 17:42:32 GMT

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

If only the PI changed and MERGE time is vastly longer, the issue could be duplicate row checking (SET table). Try CREATE MULTISET VOLATILE TABLE; do explicit GROUP BY if you need to remove potential duplicate rows.

VOLATILE tables appear as SPOOL in the user's space accounting; you can't tell them apart from other SPOOL files - but you can watch size/skew.

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