Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 May 2002 @ 17:23:51 GMT


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


Subj:   Surrogate keys on Teradata
 
From:   Richard S. Barbarick

I'm trolling for advice on implementing surrogate keys on Teradata. Do people tend to ingore this aspect of a logical model?

Teradata Design (v2.4) course endorses system assigned primary keys for space savings and to "resolve the common practice of reused data values." For a large system, an assigned key that's used as a primary index would have even data distribution.

The Teradata RDBMS Data Design v2R4.1 manual ignores surrogate keys altogether.



     
  <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