Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Do Sequences Have Any Disadvantages?

Do Sequences Have Any Disadvantages?

From: Tom McCready <mccready_at_mail.loc.gov>
Date: 1997/02/07
Message-ID: <5df9nv$3dco@rs7.loc.gov>#1/1 







I would like to hear when it is appropriate to use Sequences 
and when it is not.  Are there disadvantages to Sequences which 
would force us to keep our own table of high keys, incremented 
by one each time a record is added?


Many of our applications use a "one-up" number.  The Sybase 
implementation has some disadvantages.  How about the Oracle 
implementation?  Thank you,


Tom McCready, DBA, Library of Congress  202-707-5511

-- 
MZ


Received on Fri Feb 07 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US