Unique Index
noun
say it: “yoo-NEEK IN-deks” /juːˈniːk ˈɪndɛks/
A database index that refuses a second record with the same value in the indexed field, such as two accounts with one email.
What is Unique Index in a relational database?
Unique Index — An index that also prevents duplicate indexed value combinations.
In a sentence
- “Inserting a duplicate stall number failed with E11000 because of the unique index.”
- “A unique index on email stops a second account from signing up with ana@example.com.”
Level: Journeyman · More Database terms at this level
Updated