Archives of the TeradataForum

Message Posted: Wed, 23 Feb 2011 @ 09:43:08 GMT

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

Hi

If your insert-select query is taking very log time, then you can try merge-into. Merge-into is generally used to replace a upsert, however you can use only the 'when not matched' condition to perform inserts.

Merge-into uses less amount of CPU time.

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