Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2011 @ 19:04:21 GMT


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


Subj:   PI on multicolumns?
 
From:   Bodla, Sravan Kumar

What is the advantage of defining PI on more than 2 columns?? I understand, for even data distribution the PI should be unique and should be defined only on single column.

But I see many tables in my environment, with PI defined on 4-5 columns and more.

Can you please share your thoughts on the advantages and disadvantages on this and the data distribution on amps and accessibility of data in such cases.


Best Regards,

Sravan Kumar Bodla
TERADATA DBA



     
  <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