Unique Index

A unique index is an index that enforces the uniqueness of data in a field. For example, to ensure an employee is entered only once into an employee table, you can create a unique index on social security numbers. By doing this, a user will not be allowed to enter a social security number that currently exists in the table.