Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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