A
UNIQUE
index guarantees that the index key (one or more columns) contains no duplicate values and therefore every row in the table is in some way unique. See
Create Unique Indexes[
^].
An index that is not unique is built using one or more key columns that may be the same in more than one row of the table that is indexed.