Re: Which query is best?
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Tue, 15 Dec 2009 10:06:44 -0500
Message-ID: <9c9b9dc90912150706i2c820e48ha2c3259e0e9ce1a1_at_mail.gmail.com>
<snip>They have explained me that, they have a
SELECT .. FOR UPDATE and some other series of actions and then followed by
</snip>
Date: Tue, 15 Dec 2009 10:06:44 -0500
Message-ID: <9c9b9dc90912150706i2c820e48ha2c3259e0e9ce1a1_at_mail.gmail.com>
<snip>They have explained me that, they have a
SELECT .. FOR UPDATE and some other series of actions and then followed by
</snip>
Question -- is the update intended to update a single row or a set of rows? If the answer is a single row, then there are other ... more optimistic ... ways to get the lock that don't involve using the FOR UPDATE clause.
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 15 2009 - 09:06:44 CST