unique index on a table

unique index means that two rows cannot have the same index value.

unique index creates using the keyword unique.

For example:

Simple index:

create index myindex on tablefirst(cloumn1);

Unique index:

create unique index myindex2 on tablesecond(column2);