Difference between revisions of "Unique Key Index"
From LongJump Support Wiki
imported>Aeric m (moved Unique Index to Unique Key Index) |
imported>Aeric |
||
| (One intermediate revision 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