Case Study 3: Highly Singular Primary Index Values
A carefully selected NUPI distributes the rows of a table nearly as evenly as a UPI. If you are fortunate, the NUPI column might never contain duplicates.
The illustration shows how evenly customer table rows are hashed when a NUPI is defined on the sales_employee_number attribute.