Archives of the TeradataForum

Message Posted: Tue, 24 Aug 2004 @ 11:41:18 GMT

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

Beware of using INS-SEL approach to load a SET table from a MULTISET table. You might experience heavy skewing due to checking for Dup rows. This approach is good for very small tables.

For big tables INS-SEL-GROUP BY is the best approach and faster too.

Cheers

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