Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sequence number
. It is better to give sequence to each table .
<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
Received on Tue Nov 09 2004 - 02:17:58 CST