Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Jul 2011 @ 16:18:38 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Multiset with a UPI
From:   Pluebell, Fred

There is a subtle difference that may actually argue in favor of MULTISET for UPI tables, however odd that seems. Is it important to know that a request *would have* created duplicate rows?

In a "bulk" operation such as INSERT/SELECT, entirely duplicate rows for a target SET table would be quietly eliminated without triggering a uniqueness violation on the index. With MULTISET, duplicate rows would be detected as a uniqueness violation and cause the request to fail.

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