Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 14:35:00 GMT

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

You did not include a PRIMARY INDEX clause. It is defaulting to the first column in the result set as the NUPI, so the merge/insert phase of the CREATE ... WITH DATA is extremely skewed.

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