Archives of the TeradataForum
Message Posted: Mon, 16 Aug 2004 @ 20:43:54 GMT
Christie, Jon wrote:
Hi Jon, you probably just confused "Duplicate Rows" with "NUPI duplicates" ;-)
The essence of your first two sentences:
"duplicate row checking have to be performed because UNION guarantees that there will be no duplicate rows"
Duplicate row checks are expensive if there are lots of NUPI duplicates.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|