Subject Re: [ib-support] Re: Primary key question
Author Helen Borrie
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


All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________