Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2013 @ 10:06:50 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Diff between SET with UPI and MULTISET with UPI
From:   Adharssh.HS


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,


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019