Re: Should I use max()

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 10 May 1999 09:57:32 -0400
Message-ID: <7h6of0$8gb$1@autumn.news.rcn.net>

Hi Ray,

I suggest that you use an Oracle Sequence. You can find a good description of their
benefits and limitations in either your SQL Language Reference Manual or your SQL*Plus Language Reference Manual (depending on which version of Oracle you are running).

With over 100 users the probability of performance degradation when using the MAX function is very high.

regards

Jerry Gitomer

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 - 08:57:32 CDT