Re: NextNumbers Tables
From: osy45 <member18536_at_dbforums.com>
Date: Fri, 07 Feb 2003 18:50:07 +0000
Message-ID: <2498402.1044643807_at_dbforums.com>
Date: Fri, 07 Feb 2003 18:50:07 +0000
Message-ID: <2498402.1044643807_at_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.comReceived on Fri Feb 07 2003 - 19:50:07 CET