Primary Key Implementation

Database
Enthusiast

Primary Key Implementation

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

Tags (1)
1 REPLY

Re: Primary Key Implementation

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.