Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2008 @ 14:00:14 GMT


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

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.


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