Re: one global sequence vs seperate sequences

jou128_at_yahoo.com wrote:

> Hi all,
>
> In my current db design, I planned to create seperate sequences for
> each of the primary tables like userAccount, company etc because that
> was the norm in my previous company. In my current job, another
> developer proposed using a single global sequence for all the tables
> that needed a unique id. This will work but seems less logical because
> my thinking is that each entity should have its own set of id's.
>
> Can someone comment on this? thanks.
>
> Stan

The difference is of no consequence. Sometimes one way is the answer, other times the other way. What is the business case related to the use of surrogate keys?

The technology will do either. Which one is a matter of business rules.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)