Question: what is the difference between unique and non unique index?
Answer: A unique index ensures that no two rows of a table have duplicate values in the indexed column (or columns). A non-unique index does not impose this restriction on the indexed column's values.