Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2002 @ 19:21:34 GMT
| Subj: || || Re: Update SQL Spool Problem |
| From: || || Todd A. Walter |
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.