Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019