Re: One SEQUENCE, many tables .. need advice

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Tue, 03 Jul 2001 14:04:18 -0700
Message-ID: <3B423352.A26A1AB0@attws.com>

Anne Nolan wrote:

> Hi all,
>
> I'm working on designing a whole new database. I've decided to go with
> surrogate keys generated from sequences for most of the primary keys in
> the tables.
>
> Is it OK or even advisable to use one sequence for generating all these
> keys? Or should each table have its own sequence for generating its
> keys? I presume there is no ultimate upper limit to how big a
> sequence value can get..is this true?
>
> Thanks in advance for any and all advice on this, and sorry if this is a
> FAQ. (I did a quick search on this topic, but could find nothing.)
>
> Anne

I've done it both ways. I'm not sure there is a right answer other than if your database has a very large number of transactions occuring simultaneously.

Daniel A. Morgan Received on Tue Jul 03 2001 - 16:04:18 CDT