Archives of the TeradataForum

Message Posted: Wed, 23 Feb 2011 @ 14:21:18 GMT

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

Hmm, oddly enough, I recently found that the Merge Statement was slower than the compound time taken for an equivalent Update (through a Join), followed by an Insert Where Not Exists.

I found that, where the Table was empty, sure enough the Merge was faster than the compound of the Update and Insert but, for populated Tables it was noticeably slower.

I'd be interested in others' experience because, based upon my very recent test (in V12), I'm suggesting we DON'T change our Load Scripts to a Merge Statement.

Regards

David Clough
Database Developer
Database Design Group

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