Re: sequence number

db2group88_at_yahoo.com wrote in message news:<111e249e.0411080512.5c5090f4_at_posting.google.com>...
> before, we use DB2 identity column to generate auto number for each
> row for unique number.our application has thousands table and each one
> required to have one identity column. now we switch to oracle db 10g,
> as i know we can use sequence number to generate the number. but i
> would like to know from performance standpoint. is it better to give
> sequence to each table or use one sequence for the whole database.
> thanks

Worry less about performance and more about designing proper applications.

I think thousands of tables fighting over a sequence would likely be a bit of a performance problem.

See the thread about natural v. synthetic keys and the application developers guides http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=5

jg

--
@home.com is bogus.
Mr. Barney T!  http://www.signonsandiego.com/uniontrib/20041108/news_m1b8fivecopy.html