 |
 |
Archives of the TeradataForum
Message Posted: Wed, 12 Oct 2005 @ 10:06:24 GMT
| Subj: | | Re: Redestributing large tables instead of replicating a small table |
| |
| From: | | Victor Sokovin |
| | Not sure how to find the Orange book, googling tends to find references to "Early group by" and "Partial group by" as 1 line comments in
release summary type documents, without any actual detail as to what it is supposed to do. In the V2R5.0 manuals I can't find anything at all for
"Early group by" and minimal info on "Partial Group By". | |
| | Anyway, sounds typical that something I think will be of huge performance benefit in many of the queries that get submitted here always
appears to be in a "future release" no matter how many times we upgrade :-) | |
Orange books seem to be available to the registered customers only. For the underprivileged, they sometimes bubble up as white papers or
something but I don't see anything there on the subject of the partial group by.
Just a related question: a similar feature (or the underlying algorithm) seems to be essential for such things as ROLLUP or CUBE. I must admit
I don't see them used on large tables as yet. Could anybody share their experience with these relatively new features?
In theory, they could have been programmed better than the "traditional" features, which have gone through a long series of fixes and upgrades
(and a few generations of developers).
Regards,
Victor
| |
