Minimizing Duplicate NUPI Row Checks - Teradata Vantage

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.