Archives of the TeradataForum
Message Posted: Wed, 06 Nov 2013 @ 10:06:50 GMT
SET with UPI will not allow row duplicates and duplicates on PI. MULTISET with UPI will act as an SET table because it will not allow duplicates on PI.
SET table will be a overhead of processing for System, as it needs to check for the Dups whereas Multiset not.
INSERT into SELECT operation will silently eliminate dups rows if it is a SET table whereas error wil throw if we use a MULTISET table with an UPI.
Thanks & Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|