Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Mar 2000 @ 17:47:16 GMT


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


Subj:   Re: Re-designing Tables
 
From:   Mark Andrews

Barbara,

The primary key only comes into play if you have referential integrity turned on. Beyond that, the primary index determines how evenly your data is distributed across the amps based on uniqueness. The best performance is from a unique primary index. All the data is distributed evenly acroos the amps, so all amps are working evenly to return rows selected using the primary index.



     
  <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