Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 21 Jul 2012 @ 07:35:21 GMT


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


Subj:   Is there a difference between these CT's
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 20, 2012 04:15 -->

is there any diff between these 2 forms of CT's

Any difference in terms of insert performance between a table created a Multiset WITH a UPI and a Set table with UPI

     create Multiset  db.tb1 
     ( col1  dtype ,
     Col2 ___.
     ) Unique Primary Index ( col1)

Vs


     create set  db.tb1 
     ( col1  dtype ,
     Col2 ___.
     ) Unique Primary Index ( col1)


     
  <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