Re: Should I use max()

There will be a performance issue. The larger the table, the larger the MAX function will take to run.
Also, there is more of a possibility that 2 users will generate the same max value.
Try a sequence?

Mark

Ray wrote in message <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 - 07:50:54 CDT