Hallo Hugo,

> When should I use a Unique Key instead of a Index?
>
> I know that a Unique Key does not allow duplicated values like a Primary
> Key, but what more?

That, and it creates an index automatically. Also, if you want a column to be referenced by a foreign key, it has to be either the PRIMARY KEY or UNIQUE.


Kind regards,
Paul Vinkenoog