Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 10:59:37 GMT

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

What do the following mean ?

1. The result goes into Spool 1 (group_amps), which is built locally on the AMPs.

2. We do an all-AMPs RETRIEVE step from CHK.B by way of an all-rows scan with a condition of ("NOT (CHK.B.b IS NULL)") into Spool 2 (all_amps), which is redistributed by hash code to all AMPs.

I am looking for answers to the words {Spool 1(group_amps)} and {Spool 2 (all_amps)}.

Narayan

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