Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 06 Jun 2005 @ 20:24:41 GMT





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




Subj:   Re: V2R5.1 dynamic partition elimination
 
From:   Ole Dunweber



Hello Eric,

I'm a little confused as to whether the reply below is to my post? I believe I wrote, that DPE works in 5.1.2 in the following case:

     "
     select DayId, SUM(Fact)
       from PPI-table A,
            Lookup_Day B
      where A.DayId = B.DayId
        and B.WeekId = 200520"

where PI of the PPI-table includes DayId.

At least thats what I intended to write.


Sorry if I have caused confusion.

Ole Dunweber
Coop Nordic





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008