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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016