Add a new snippet
Error And Resolution
Difference between UPI vs PI in Teradata
Difference between UPI vs PI
Unique primary index and Non-unique primary index are associated with SET and MULTISET tables respectively.
For a SET table, Unique primary index is always defined. The reason behind is in order to avoid the overhead of duplicate check. If UPI is not defined for SET table, then the SET table itself will scan the entire records to find out the duplicates whereas UPI proactively checks duplicate entry. Since less columns are defined under UPI, it finds duplicate records faster than SET.
NUPI otherwise will be used for MULTISET tables. Since Multiset table does not look for duplicate entries, NUPI will be just used to index fields.
Difference in brief:
Defined for SET table
Defined for MULTISET table
Duplicate check is handled by UPI
No duplicate check is handled
UPI reduces overhead for SET for duplicates
NUPI will be used for indexing purpose only.
Tags for Difference between UPI vs PI in Teradata
unique primary index vs primary index
difference in unique index
Difference between unique primary index and non unique primary index
upi on partition vs table in teradata
diddwrence between UPI and NUPI
DEFINING A NUPI IN TERADATA
teradata upi and pi
teradata nupi vs pi
nupi with multiset table
multiset table with unique primary index checks duplicacy
Contribute to Forget Code, help others.