Re: Should I use max()

A copy of this was sent to "Ray" <raymond_at_gmwgroup.com> (if that email address didn't require changing) On 10 May 1999 12:27:52 GMT, you wrote:

>Should I use max(n)+1 to assign a new seq. no. on a large table with >100
>user environment?
>Any performance issue?
>
>Raymond

Is there any reason why you cannot use a sequence?

"select my_sequence_name.nextval from dual"

will generate a non-blocking sequence number. Many users can select from it, each getting their own sequence number without blocking eachother.

Using a table with max(n)+1 will serialize all transactions (only 1 transaction at a time).

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 10 1999 - 07:51:16 CDT