Why would you choose a Non-Unique Primary Index (NUPI) instead of a Unique Primary Index (UPI)?
A NUPI requires less disk space to store the data row.
A NUPI may be more effective for query access and joins.
A NUPI query amplifies the optimization process in the PE.
A NUPI provides better data distribution