Quote:
Originally posted by tompoes
You are write, but the application is already running by more then 600 companies. with over 200 tables
And the generation of the key with a table , is the way we do it.
So i can not change the structure.
Some other ideas.
|
You are writing new functions, new triggers, ... I don't see how you are therefore restricted to continuing to use a bad technique. For Oracle, the trigger should select the next value from a sequence; for other DBMSs where the column type is IDENTITY the trigger is not required at all (or can be a dummy). Your key tables can just fall into disuse.