Archives of the TeradataForum

Message Posted: Wed, 22 Jun 2005 @ 12:36:10 GMT

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

Typically so that it can do a row-hash match scan. This requires that the two objects to be jined are in the same sorted order - and Teradata's 'order' is row hash.

Look at the step where the sort is happening and find the number of the OUTPUT spool file. Now find the next place where that spool file is used, it will typically be a row-hash match scan.

Cheers,

Dave

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