Why to Choose a Non Unique primary index instead of a unique primary index
A Non Unique primary index may be more effective for query access and joins
A NUPI query simplifies the optimization process in the PE
A NUPI provides better data distribution
A NUPI requires less disk space to store the data row