Question: what is the difference between unique index and unique constraint?
Answer: A unique index ensures that the values in the index key columns are unique. A unique constraint also guarantees that no duplicate values can be inserted into the column(s) on which the constraint is created.