UPI or NUPI

Database
Enthusiast

UPI or NUPI

Hi all,

What are the criteria on which a developer can decide that whether go for UPI or NUPI.
Like there is one table and has col1, col2, col3......., col 10.

And he can define UPI on col1 and NUPI on col2.
Then for which index he or she will go and why?

1 REPLY
Enthusiast

Re: UPI or NUPI

Generally it depends on business criteria...
You can have NUPI+SET or UPI+MULTISET.......
For other things please refer Teradata manuals .......