Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2003 @ 19:44:47 GMT

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

Aniruddha,

Your second query is performing a 'Full Outer Join' (the equivalent of a Left and Right Outer Join at the same time.) Typically, 'Full Outer Joins' will be slower than a Left Outer Join.

Hope this helps,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, Inc.

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