Unique Key Index

A Unique Index is an index for which there are no duplicate index keys. With such an index, every key points to one and only one record.

For example:

• In a case management system, every case number is unique.
• In a list of companies, every company name is unique.
• In a list of U.S. citizens, every social security number is unique.

Learn more:

• Create an Index (Enable Unique Key option)
• Choosing Fields for Indexes