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