Re: design question

Ed Prochak wrote:

> On Oct 28, 3:06 am, robu..._at_gmail.com wrote:

>> Sorry, I was in hurry so I was not very clear. I mean some people
>> prefer to use surrogate (primary) keys instead of natural composite
>> keys and then use foreign keys to surrogates just for making joins
>> "faster". A bad idea in my opinion...
>
> I favor your view. There is a time and place for surrogates, but too
> many jump to using ID columns as the PK right away.

Worse still, it is widely considered "best practice" to do so.

At least no one will die.

-- 
Roy