Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 02 Aug 2006 @ 16:59:25 GMT





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




Subj:   Unique Primary Index Vs Non Unique Primary Index
 
From:   Subrahmanian Kalyanasundaram



Hi,

I am having some doubts in Unique Primary Indexes and Non - Unique Primary Indexes, for example, my database is having 2 amps and i am inserting 100 records to a table, whether the record will be distributed in both the amps in both UPI & NUPI, then how the records will be (inserted)distributed to the 2 amps in both Unique Primary Index and Non - Unique primary index.


Thanks & Regards,

K.Subrahmanian





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