Thanks for the answer.
Ann, what about the article_ID field, many fields could be empty, then I
guess I better generate a normal index on that field ?

Thanks, Nico

----- Original Message -----
From: Ann W. Harrison <aharrison@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, July 20, 2001 9:44 PM
Subject: Re: [ib-support] Primary key question


> At 08:19 PM 7/20/2001 +0200, Nico Callewaert wrote:
>
> > The problem is : for some articles , there is no article number. Now,
I
> > guess I have to use a surrogate key, with numbers generated by a
> > generator. Isn't that a little bit wasted space ? That field doesn't
> > have really a meaning, but I think it's the only way do do it ?
>
> Not only is it the only way to do it, it's probably the best way as well.
> Yes, you'll be storing 8 extra bytes per record, but consider the value of
> your sanity...
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>