Unique index

A unique index on a table guarantees that the index key contains no duplicate values.

Specifying a unique index makes sense only when uniqueness is a essential for the data in a table.

You can view a table's indexes as well as create your own index for a table using the table's related list of indexes.