one global sequence vs seperate sequences

Hi all,

In my current db design, I planned to create seperate sequences for each of the primary tables like userAccount, company etc because that was the norm in my previous company. In my current job, another developer proposed using a single global sequence for all the tables that needed a unique id. This will work but seems less logical because my thinking is that each entity should have its own set of id's.

Can someone comment on this? thanks.

Stan Received on Tue Mar 22 2005 - 12:30:53 CST