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

Home -> Community -> Usenet -> comp.databases.theory -> Re: NextNumbers Tables

Re: NextNumbers Tables

From: osy45 <member18536_at_dbforums.com>
Date: Fri, 07 Feb 2003 18:50:07 +0000
Message-ID: <2498402.1044643807@dbforums.com> 






why a table for surrogat keys?



rdbms systems like oracle, db2, sybase offer identity column
capability..


sorry oracle uses sequences instead.



the problem with tables for surrogat keys tables is that if there a a
large number of connection retrieving the high water marks an updating
the table they are causing a lot of (dead)locks ..


--
Posted via http://dbforums.com


Received on Fri Feb 07 2003 - 12:50:07 CST












Original text of this message













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