Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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