Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 11 Oct 2005 @ 21:36:34 GMT

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

Subj:   Re: Redestributing large tables instead of replicating a small table
From:   Dieter Noeth

Howard Bradley wroteb:

  I was told (many moons ago) that there would be a feature of the optimiser in V2R5 that would address some of the queries which fall foul of this redistribution. At the time it was described to me as "early aggregation", and I have since heard it referred to as "partial group by" although I am not convinced these are one and the same thing.  

"Early Group By" or "Partial group By", i think there was an Orange Book about it.

  Has anybody heard of this or got any clue what I am talking about or did I just dream it ?  

It was so buggy in V2R5 that it's usually switched off, AFAIR there's a recommendation to switch it on in V2R6 or V2R6.1?


  <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: 15 Jun 2023