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
