Re: NextNumbers Tables

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 14 Feb 2003 09:53:43 -0600
Message-ID: <Xns93225A7DEB9Cpingottpingottbah_at_216.166.71.233> (Saul Margolis) wrote in

> 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
Received on Fri Feb 14 2003 - 16:53:43 CET

Original text of this message