Difference between revisions of "Unique Key Index"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
(One intermediate revision by the same user not shown) | |
(No difference)
|
Latest revision as of 03:00, 12 October 2012
A Unique Key Index is an index in which there are no duplicate 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 an index 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