Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • Well, advisory locks are different from explicit locking. Advisory locks aren't enforced by database engine. Commented Sep 12, 2019 at 20:19
  • 2
    You're right, I fixed this section. Commented Sep 12, 2019 at 20:21
  • Thank you! So does this try to get an advisory lock on each row that matches the IN clause and lock it just while updating it, or does it somehow advisor lock all of them first and then update? Commented Sep 12, 2019 at 22:12
  • 1
    AFAIK the 1st statement. The lock is evaluated at the predicate time, that is when it's evaluating the where clause. Commented Sep 12, 2019 at 23:42
  • 1
    Appreciate your help! Commented Sep 13, 2019 at 0:15