Archives of the TeradataForum
Message Posted: Mon, 15 Mar 2004 @ 17:27:16 GMT
I've seen the same things with UNION. (I think) What's happening is that Teradata is hashing the entire row and distributing based on that hash, then looking within the set of rows with same rowhash for duplicates in order to do the MINUS function. "It ain't pretty" and it could be done another way, but I think you'll find that is what is happening.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|