Archives of the TeradataForum
Message Posted: Thu, 03 Apr 2008 @ 14:00:14 GMT
| Subj: || || Re: PPI/constant view issue on V2R6.2 |
| From: || || Lubomir Ilanovsky |
| ||I do not know what to comment yet but I noticed something I'd like you to comment on first.|| |
| ||The R6 explain contains this line:|| |
| ||dw.transaction.Post_Date = DWE_DATE"|| |
| ||The DDL you included in your posting does not mention the DWE_DATE.|| |
Before posting to this forum I tried to anonymize our SQL and explains a little bit. Unfortunatelly I've forgotten to change DWE_DATE to
DW_DATE in explain from V2R6. Correctly the explain should look like this
6) We do an all-AMPs JOIN step from Spool 5 (Last Use) by way of an
all-rows scan, which is joined to dw.transaction by way
of an all-rows scan with no residual conditions. Spool 5 and
dw.transaction are joined using a product join, with a
join condition of ("dw.transaction.Post_Date = DW_DATE").
The input table dw.transaction will not be cached in
memory, but it is eligible for synchronized scanning. The result
goes into Spool 4 (group_amps), which is built locally on the AMPs.
The size of Spool 4 is estimated with no confidence to be 2,375,660
rows. The estimated time for this step is 1 minute and 5 seconds.