Re: Artificial Primary keys
Date: Thu, 7 Feb 2002 16:43:47 -0800
Message-ID: <u667rcbhpnsj4d_at_corp.supernews.com>
"B. Hawes" <bhawes_at_satx.rr.com> wrote in message <news:d478259.0202071146.7bce89b4_at_posting.google.com>...
> And something additional that hasn't been mentioned yet, in
> applauding the join response time gained by using generated surrogate
> keys, be sure to offset that with the additional cost & maintenace of
> maintaining a redundant unique index on the table when there is
> already perfectly valid one that 99% of the users will actually be
> using in queries. (employee-id, start_date).
What then is this "employee-id", a divinely-guaranteed-unique label affixed to every newborn by God Himself? Where did we get this idea that OIDs may come from pieces of paper (invoice numbers, anyone?) but absolutely nowhere else? So-called "natural" keys are often as arbitrary as any synthetic key!
-- Joe Foster <mailto:jlfoster%40znet.com> Got Thetans? <http://www.xenu.net/> WARNING: I cannot be held responsible for the above They're coming to because my cats have apparently learned to type. take me away, ha ha!Received on Fri Feb 08 2002 - 01:43:47 CET