Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2008 @ 11:36:34 GMT


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


Subj:   Re: PPI/constant view issue on V2R6.2
 
From:   Victor Sokovin

  Does anybody know why the behaviour on V2R6 is not consistent? Is there any way to prevent this?  


Lubomir,

The observations you have made seem to contradict our expectations of partition elimination being improved in the latest releases compared to earlier releases, where partition elimination was rather limited (understandably so: partitioning was a brand new feature at the time).

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. I wonder where the difference in the names comes from. Could you please check whether all the relevant information is included and it is correct?


Victor



     
  <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: 27 Dec 2016