Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 15 Nov 2002 @ 17:29:44 GMT


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


Subj:   Re: Rowid and hash functions
 
From:   Belle, Patrick A

Thomas,

You're absolutely correct. The primary index is a physical distribution attribute and is not the primary key. Teradata has another clause to identify the primary key and we shouldn't confuse them. For unique identification, you need the primary key and for distribution, you need the primary index. The confusion is caused by the fact that they do often overlap.

Pat Belle
Teradata Certified Master



     
  <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: 28 Jun 2020