Re: NextNumbers Tables

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