Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: NextNumbers Tables

Re: NextNumbers Tables

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 14 Feb 2003 09:53:43 -0600
Message-ID: <Xns93225A7DEB9Cpingottpingottbah@216.166.71.233>


saul_margolis_at_hotmail.com (Saul Margolis) wrote in news:c20aa081.0302140208.4f10eee6_at_posting.google.com:

> This is exactly the way I try to do things, having a surrogate key
> and natural key with a unique index.
>
> Ever tried tracing a transaction manually (as one is sometimes
> forced to do) when you only have a natural key consisting of 10
> fields?

Exactly! This is why when people jump up and down about how surrogate keys shouldn't be used, I shake my head and realize that these folks have never worked on a large production environment.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com
Received on Fri Feb 14 2003 - 09:53:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US