# 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](https://www.ask-codey.com/glossary?category=database&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/unique-index
