Unique Key Index

From AgileApps Support Wiki
Revision as of 19:35, 29 December 2011 by imported>Aeric (Created page with "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…")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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: