How is primary key concept implemented in teradata?(like primary index is implemented using hash algorithm).
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.