Re: Default column value of MAX +1 of column - possible in Oracle 9i?

jeez.
if you're going to insert 100,000 rows, don't use a sequence with an increment of 1.

I remember a phrase of "what is the fastest way to do :x?" "Don't do :x."

Use a sequence with an increment of say 1000 and keep track of the counter in your proc. That will really minimize the recursive sql.

I don't mean to slight your use of a real example, kudos for doing so.

I just think 100000 rows constitues a batch job where single row oltp stuff need not apply.

-bdbafh Received on Fri Mar 25 2005 - 00:37:54 CST