--- In ib-support@yahoogroups.com, "Ann W. Harrison" <aharrison@i...>
wrote:

>
> There won't be any more effect from this than from any other
> index, but the real answer lies in your application. Either
> a unique index or a UNIQUE constraint will be faster and more
> reliable than any other method. Have you modelled this?
>
>

I was advised to create short index when I was using MySQL. So I
concern whether it is the same when using Firebird. It seems Firebird
does not have this issue from the replies I got here. Hope I did not
misunderstand.

Thanks,
Michael