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?)
There is an elaborate explanation in the Database Design document for your database version:
is for V15.10
Thanks For replying rupert. I went throught the document gave me a better understanding on the selection criteria.