Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2005 @ 17:56:46 GMT


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


Subj:   MULTISET Tables
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 29, 2005 11:25 -->

Can someone please point out the plus and cons of defining a table as MULTISET?

I personally do not like them and avoid them in my designs but we have an application that has one table with 3B rows and approximately 150 repeated values on each Primary Index value.

It voraciously consumes gobs of CPU inserting and updating less than 20M rows once a week.

Please share any good, bad, and ugly experiences you have encountered with multiset tables


Thanks,

Anonym



     
  <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: 27 Dec 2016