You can minimize or eliminate duplicate NUPI row checks while preventing duplicate row from being inserted. This topic describes ways to achieve that goal.
- Use a non-primary index column set to define a UNIQUE constraint or USI.
- Use multiple columns to define NUPIs to make the index as close to being unique as possible.
- Keep the number of NUPI duplicate rows for each value below 100.