Re: Should I use max()

remark about the use of a sequence.

When ( for any reason ) you need to be sure that there are no gaps in the values of your keys using a sequence can cause problems. ( --> real time problem
taken from an insurance company in europe ) It's possible that a user does a select of het sequence, but does not commit
the insert statement .
To avoid this problem -> put the selection of the sequence in a before-insert-row trigger.

Gert

Ray <raymond_at_gmwgroup.com> wrote in article <01be9ae0$58a7db20$9e5b4cca_at_Raymond.gmw.com>...
> Should I use max(n)+1 to assign a new seq. no. on a large table with >100
> user environment?
> Any performance issue?
>
> Raymond
>
Received on Mon May 10 1999 - 15:15:51 CDT