Subject Re: [firebird-support] Unique vs Index...
Author Ann W. Harrison
At 02:45 PM 12/17/2004, Chad Z. Hower aka Kudzu wrote:

>Im sure this has been asked a billion times.. Is there a FAQ or article on
>this? I want to reasearch it in full - but my primary question is:
>
>Will unique require less storage space?

A unique constraint creates an index to enforce uniqueness. The
major difference between a unique constraint and a unique index
is that you can use a field - or list of fields - that are the
subject of a unique constraint as the referenced (aka parent)
in a foreign key relationship.

Regards,


Ann