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


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: 15 Jun 2023