AgileApps Support Wiki Pre Release

Difference between revisions of "Unique Key Index"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
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.
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:
For example:
:* In a case management system, every case number is unique.
:* In a Case Management system, every case number is unique.
:* In a list of companies, every company name 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.
:* In a list of U.S. citizens, every social security number is unique.



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: