Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 25 Aug 2004 @ 08:01:45 GMT





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




Subj:   MULTISET Vs SET tables
 
From:   Jayasena, Rajah



I am trying to find out the pros and cons of defining a table as Multiset.

If our loading processes will never load duplicate rows, is it a good idea to have the tables defined as Multiset, to improve the Multiload performance.

What are the possible problems (other than allowing duplicates) of defining a table as Multiset.


Cheers

Rajah.





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008