Re: combined Primary key's ... newbie
From: Ray DiMarcello <rdimarcello_at_ingva.com>
Date: Fri, 28 Sep 2001 14:51:29 -0400
Message-ID: <9p2gs6$l52$1_at_bob.news.rcn.net>
Date: Fri, 28 Sep 2001 14:51:29 -0400
Message-ID: <9p2gs6$l52$1_at_bob.news.rcn.net>
What do you mean "validate the dummy key against the natural key" ... "the database will get corrupted" ???
--CELKO-- <71062.1056_at_compuserve.com> wrote in message ...
>>> I've normalised my documents and ended up with a lot of compound
>primary
>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