Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Apr 2011 @ 21:00:12 GMT


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


Subj:   NUPI a performance killer in MLoad?
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, April 28, 2011 06:59 -->

HI All,

I read from TD MultiLoad reference manual that "Verify that the primary index is unique. NUPIs can cause severe MultiLoad performance problems"

I wonder if this applies for Multiset tables as well?. As per my understanding, multiset table will not check for row duplicates and hence faster(over set table) and also if we have NUPI on top of multiset, it will skip PI duplicate check and hence a Multiset table with NUPI should be the fastest option we have in TD.

Can someone correct me if I am wrong


Thanks



     
  <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