Question: what is difference between unique index and index?
Answer: Differences. KEY or INDEX refers to a normal non-unique index. ... UNIQUE refers to an index where all rows of the index must be unique. That is, the same row may not have identical non-NULL values for all columns in this index as another row.