Archives of the TeradataForum
Message Posted: Mon, 15 Mar 2004 @ 18:06:01 GMT
On Mon, 15 Mar 2004 17:27:16 -0000, David Wellman wrote:
Eww! That really does sound awful. Why doesn't it spool out locally on each AMP, hashing the entire row and ordering by that value, and do its checking there? I don't see any gain whatsoever in redistributing rows when both tables have identical PIs.
But thank you, David, for confirming that what I see here is what's actually happening, however unattractive it may be.
All the best,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|