Question: what is the difference between unique and nonunique index?
Answer: Unique and non-unique indexes. Unique indexes are indexes that help maintain data integrity by ensuring that no two rows of data in a table have identical key values. ... When a unique index is defined for a table, uniqueness is enforced whenever keys are added or changed within the index.