Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 13:24:36 GMT

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

"Union All" is faster because it ignores 9(and returns) duplicate rows.

"Union" will sort and eliminate duplicates, returning just one unique row in the two sets being combined.

Michael E. McBride, MSCIS

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