Tags for USI
PK used as USI and not UPI
What are the reason(s) why a PK will be implemented as USI instead of UPI? This question was formulated based on the following statement:"Primary keys are implemented as unique secondary indexes for non-temporal tables..."
database design primary key PK Unique Secondary Index USI unique primary index upi physical data model pdm Data Definition Language ddl
Select Columns for UPI,NUPI,USI and NUSI
Hello All,   Can someone explain on what basis we select indexes for the columns in the field. Following is my understand: UPI -> When we have Unique value, which is evenly distributed to all the AMPS. (The column selected for UPI looks like a field Eligible for USI as well. Then how to decide?)
upi nupi USI nusi