Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 15:46:43 GMT

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

<-- Anonymously Posted: Tuesday, April 24, 2007 09:04 -->

Have you considered creating USI on the source table? Teradata is sometimes smart enough to avoid dup check if it knows the source has no duplicates.

Newer versions of Teradata may also be smarter about dup check with INSERT/SELECT as long as you are using fast-path insert (empty target with no secondary indexes).

If you are going to FastExport to pipe, use FastLoad rather than MultiLoad.

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