Unique Constraints

Difficulty: Beginner

Question

Is a Unique Constraint the same as a Unique Index?

Answer

Functional identical. A unique constraint ensures no duplicates; the database typically implements this internally using a unique index to check for violators quickly.

Concepts covered

Integrity, Indexing