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
ipi vs nupi teradata
how to define upi and nupi teradata
diiference between upi and nupi
difference upi and pi
difference between pi and upi in teradata
difference between upi and non upi
difference between set pi and set upi
Contribute to Forget Code, help others.