Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2002 @ 19:21:34 GMT

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

This step and the redistribution/spooling that goes before tell me that the data type of "ban" is not the same in the two tables and that the Primary Index of the work table is not the same as the Primary Index of the production table. Making them both the same data type will help a lot because then a normal merge join can be done. Giving the two tables the same PI will help even more because they will not have to be redistributed and spooled before the join.

4) We do an all-AMPs JOIN step from Spool 2 (Last Use) by way of an
   all-rows scan, which is joined to Spool 3 (Last Use).
   Spool 2 and Spool 3 are joined using a single partition hash join,
   with a join condition of ("((BAN )= (BAN (CHAR(10), CHARACTER SET LATIN, NOT
   CASESPECIFIC, FORMAT '---------9.')(CHAR(10), CHARACTER SET LATIN,
   NOT CASESPECIFIC, NAMED BAN )(FLOAT, FORMAT
   '-9.99999999999999E-999')LATIN)) AND ((ENT_SEQ_NO =
   ORIG_ENT_SEQ_NO) AND ((ACTV_SEQ_NO = ORIG_ACTV_SEQ_NO) AND
   (ACTV_CODE = ACTV_CODE )))").  The result goes into Spool 1, which
   is redistributed by hash code to all AMPs.  Then we do a SORT to
   order Spool 1 by the sort key in spool field1.  The size of Spool
   1 is estimated with low confidence to be 237,745,954 rows.  The
   estimated time for this step is 4 minutes and 17 seconds.

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