 |
 |
Archives of the TeradataForum
Message Posted: Tue, 11 Oct 2005 @ 21:36:34 GMT
| 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?
Dieter
| |
