O'Reilly logo
  • Lucas Reis thinks this is interesting:

When you create a B-tree index, you can also specify that the index be unique. Doing so ensures that non-NULL values are unique when you insert or update columns in a table.

From

Cover of Pro Oracle Database 11g Administration

Note

unique index