Re: How long is long enough for primary key ?

krislioe_at_gmail.com wrote:
> Hi,
> Thank you for your response.
>
> > why not use that for PK?
> >Adding an extra index (PK + UK) will
> >cause extra overhead on inserts, which
> >will affect performance negatively.
>
> I don't use PORef as PK , because the user should be able to change it.
> That is the reason.
>
> I have no other choice but using PK+UK, do I ?
>
> Thank you,
> xtanto
>

<snip>

Interesting. If the PORef is user (customer?) supplied, and you define it as unique, how do you guarantee that customer "A" doesn't supply the same PO# as customer "B"? Received on Mon Oct 09 2006 - 08:03:46 CDT