Question: what is the difference between unique key and unique index in oracle?
Answer: Unique Constraint. A constraint has different meaning to an index. It gives the optimiser more information and allows you to have foreign keys on the column, whereas a unique index doesn't.