--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:

> At 03:05 PM 17-04-01 +0000, you wrote:
> >--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> >
> > > You will have to apply a unique constraint across the
> >columns of the existing key to ensure that the data itself obeys

the

> >requirement for uniqueness.
> > >
> >
> > Hi, Helen. I prefer general indexes for 2 reasons:
> >1. I can rebuild them making inactive/active.
> >2. They are comfortable when explicitly planning inner joins.
>
>
> Is that relevant to a question about primary keys?
>
> Helen
>

No. It is relevant to give Niko more information about
considerations that can be taken into account when he will make
deceision how he will support "natural" uniqueness in his table. And
maybe not only to Nico but more people reading list. It is not
opposition to you, you answer for primary question was much clear
than my, it is addition. Unique constraint provides advantage that it
allow reference if needed, general index - another advantage, we can
choice what we need in particular cases. Yes, this question was not
asked but it logically follows.

Best regards. Without irony.