Tuesday, September 18, 2012

When to use "SELECT FOR UPDATE NOWAIT"

  • Verify the data has not changed since you queried it out (preventing lost updates). 
  • Lock the row (preventing the UPDATE or DELETE from blocking).
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)