sequence number

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 Mon Nov 08 2004 - 07:12:11 CST