Select Columns for UPI,NUPI,USI and NUSI

Database

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?)

NUPI -> Distributes the columns depending on the key on which it is defined.(This column has repeated values and seems to be eligible for NUSI. Then how to decide?)

Thank You.

Tags (4)
2 REPLIES

Re: Select Columns for UPI,NUPI,USI and NUSI

There is an elaborate explanation in the Database Design document for your database version:

B035-1094-151K

is for V15.10

Re: Select Columns for UPI,NUPI,USI and NUSI

Thanks For replying rupert. I went throught the document gave me a better understanding on the selection criteria.