Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 19:47:30 GMT


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


Subj:   Re: Aggregate Intermediate Results computed locally/globally
 
From:   Ole Dunweber

Hello Anomy

Thank you for answering.

You wrote "Presumably the PI of the aggregate table would be the same as your GROUP BY columns."

This is not case. But the PI of the aggregate table is "contained" in the group by columns, ie:

     PI of base-table = (Column1,Column2)
     PI og aggregate table = (Column1,Column2)
     Group by columns = (Column1,Column2,some other columns)

Ole Dunweber



     
  <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