Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: combined Primary key's ... newbie

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@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 - 13:51:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US