Difference between revisions of "Unique Key Index"
From LongJump Support Wiki
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…") |
imported>Aeric |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
A ''Unique Index'' is an index | 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 | :* In a Case Management system, every case number is unique. | ||
:* In | :* 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. | ||
| Line 9: | Line 9: | ||
:* [[Indexes#Create_an_Index|Create an Index]] ('''Enable Unique Key''' option) | :* [[Indexes#Create_an_Index|Create an Index]] ('''Enable Unique Key''' option) | ||
:* [[Indexes#Choosing_Fields_for_Indexes|Choosing Fields for Indexes]] | :* [[Indexes#Choosing_Fields_for_Indexes|Choosing Fields for Indexes]] | ||
<noinclude> | |||
[[Category:Data]] | |||
[[Category:{{features}}]] | |||
[[Category:Objects]] | |||
[[Category:Glossary]] | |||
</noinclude> | |||
Latest revision as of 19:40, 29 December 2011
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