All Forums Database
Kishore_1 208 posts Joined 03/10
26 Dec 2011
Primary Key Implementation

How is primary key concept implemented in teradata?(like primary index is implemented using hash algorithm).

Kamran.Shirazi 2 posts Joined 10/06
08 May 2013

Primary Key is implemented as either UPI or USI. If you've already defined a PI on the table and adding a PK, it will be created as a USI. However, if your table doesn't have a Index defined and only have a PK then TD will create a UPI on that PK.

You must sign in to leave a comment.