Jack wrote:
> . 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
Why?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Nov 11 2004 - 23:51:42 CST
