Re: design question

On Nov 5, 1:17 pm, "Walter Mitty" <wami...@xxxxxxxxxxx> wrote:
"Ed Prochak" <edproc...@xxxxxxxxx> wrote in message

news:98c0f37a-3594-4158-9e7a-c525b9e50df7@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 28, 3:06 am, robu...@xxxxxxxxx wrote:

Walter Mitty wrote:
<robu...@xxxxxxxxx> wrote in message
Are you sure you don't mean "primary keys made up by composing several
foreign keys"? Just a guess on my part, since I don't really know what
you
mean.

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.

I also agree.  I only use ID columns for "entity tables" not "relationship
tables".  And I only use them when there are no reliable natural keys
available.

So aptly and simply put. Why this isn't at the top, printed in bold,
of texts on the subject I have no idea.
.

Relevant Pages

  • Re: Trying to optimize a query with a bunch of INNER JOINs
    ... how fast is it if you drop out the SUM and the ... > Yes, I do have foreign keys on the main table, as well as primary keys on ...
    (microsoft.public.sqlserver.programming)
  • Re: Trying to optimize a query with a bunch of INNER JOINs
    ... Yes, I do have foreign keys on the main table, as well as primary keys on ... > Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • Re: Premature sending of e-mail replies
    ... > Frequently when composing a reply I accidentally hit a combination of keys ... > Does anyone know the keys that do it or if I can turn the feature off? ... is toggle Work Offline back Online and it will go without you having ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Premature sending of e-mail replies
    ... My OE6 is suffering from premature transmission! ... Frequently when composing a reply I accidentally hit a combination of keys ... Does anyone know the keys that do it or if I can turn the feature off? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Premature sending of e-mail replies
    ... > My OE6 is suffering from premature transmission! ... > Frequently when composing a reply I accidentally hit a combination of keys ... > Does anyone know the keys that do it or if I can turn the feature off? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)