Archives of the TeradataForum

Message Posted: Tue, 24 Jul 2012 @ 19:30:28 GMT


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

Subj:		Re: Insert statement starts OK but then slows down

From:		Dieter Noeth

Todd Walter wrote:

The select portion of an insert select is always executed as a Select > Distinct to eliminate any duplicates from the source.

Hopefully not :-)

Otherwise it would be impossible to insert select from multiset to multiset.

Dieter


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

Archives

2012 Indexes

Last Modified: 15 Jun 2023