Re: NextNumbers Tables

From: osy45 <>
Date: Fri, 07 Feb 2003 18:50:07 +0000
Message-ID: <>

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
Received on Fri Feb 07 2003 - 19:50:07 CET

Original text of this message