why? on a purely intellectual curiosity level, why?
I'm not disagreeing with the practice, but if you are using a sequence
to generate the primary key, you are not using a natural key and the
value of the key SHOULD NOT MATTER. Whether it is in some vague
sequential order or whether there are major gaps. It doesn't matter.
If you need true sequential values, with no gaps, then you shouldn't be
using a sequence to generate them. You are now placing meaning on that
value.
- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> wrote:
> If you are using the sequence to generate the primary key for a
> table, then the sequence should only be used for that table. I can't
> think of a pro to have one sequence shared for the primary keys on
> many different tables.
>
> > -----Original Message-----
> > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf
> Of
> > Chris Grabowy
> >
> > Well, there could be business logic reasons as to why you
> > would have one
> > sequence per table.
> >
> > Also, I don't know if I would ever go with one sequence for
> > many tables,
> > sounds like a bottle neck to me. And how would one sequence
> > for many tables
> > impact scalability?? Or having lots of users hammering the
> > database?? And
> > what happens if you have to reset the sequence, then you have
> > to check the
> > primary key values on many tables. One sequence to one table
> > sounds good to
> > me, but I would love to hear pros/cons about this...
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jacques Kilchoer
> INET: Jacques.Kilchoer_at_quest.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Received on Wed Jul 16 2003 - 15:23:41 CDT
