What is the primary index in Teradata?
In Teradata, the primary index is an index present on a set of fields which includes the primary key for the field and is guaranteed not to contain any duplicates.
There are two types of primary indexes:
- UPI / Unique Primary Index
- NUPI /Non-Unique Primary Index