INSERTing maximum value

RakshaPai · Post by **RakshaPai** » Wed Jul 25, 2007 5:00 am

There are no issues with the availablity of the database.

What i am wondering is - selecting max from the same table and inserting into the same table, would it create a dead lock due to locking issues on the table?
i am not sure if SELECT MAX is going to have a EXCLUSIVE lock on the table. in that case there would be a deadlock during the insert.

i don know if i m correct here.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 25, 2007 1:18 pm

You are doing a normal lookup. The query will finish in the LUT_Create operation, and release any lock it may hold. The table will be updated downstream of the LUT_Process operation. There will be no lock issues from this quarter.

RakshaPai · Post by **RakshaPai** » Wed Jul 25, 2007 11:26 pm

ok.. that sounds good..

will do it in a single job then :D

thanks for all ur inputs guys....