Re: share sequences between tables or one to one

Todd Storch schrieb am 10-Dez-97 15:59:46 zum Thema "share sequences between tables or one to one":
>I inherited a schema that uses sequences that are shared between tables.
>When a sequence needs to be recreated I have to check the MAX value for
>several tables then set the start value of the sequence. This can be time
>consuming when many tables use the same sequence. Is there any down side
>to creating a sequence for each table in the schema. i.e. TABLENAME_SEQ ?

I think, when You have a sequence for every table forces You to eventually recreate many sequences which is also time consuming when You have to get the maximum numbers. You can do this one after another so you have several small runtimes instead of one big.
Apart from this I don't think there is no drawback having a sequence for every table. Of course you have to update all references to your only sequences when introducing the new sequence names.

>Thanks

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |