Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2008 @ 19:28:43 GMT

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

The ON clause defines matching, not filtering. So in Query B you are not "restricting" the number of USING rows processed, just forcing WHEN NOT MATCHED action (i.e. INSERT) for most of them.

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