Re: Surrogate Key vs Production Key

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 10 Oct 2004 23:01:44 -0700
Message-ID: <73e20c6c.0410102201.785cc6ac@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097431960.682256_at_yasure>...
> > Arguments, you want? Already supplied a few. Here is more:
>
> I don't think you truly have an argument as I can not think of a single
> time in the last 5 years I have found a reason to update (modify) a
> natural key. I think you've been eating too much red herring ... try
> salmon instead.

And I think you're day dreaming. Try a search on google. Name ONE commercial application that uses natural keys instead of surrogate keys.

Now, you may choose to ignore the vast majority of the IT market. For the sake of hiding the problem Oracle has with sequences in RAC.

But you are doing that on your own. Just don't give me the bullshit about "have never found that anywhere". You know perfectly well it is not true. Received on Mon Oct 11 2004 - 01:01:44 CDT