Archives of the TeradataForum

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

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

<-- 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>>