Re: combined Primary key's ... newbie

From: Ray DiMarcello <>
Date: Fri, 28 Sep 2001 14:51:29 -0400
Message-ID: <9p2gs6$l52$>

What do you mean "validate the dummy key against the natural key" ... "the database will get corrupted" ???

--CELKO-- <> wrote in message ...
>>> I've normalised my documents and ended up with a lot of compound
>key's (up to 4) in my tables. They contains more foreign key's than
>actual data. <<
>That can happen and it is fine.
>If you add a single column dummy key, you would still have to have
>uniqueness constraints on the present keys, then you would have to
>validate the dummy key against the natural key. You will probably get
>faster joins, but the database will get corrupted.
Received on Fri Sep 28 2001 - 20:51:29 CEST

Original text of this message