Press "Enter" to skip to content

Fun with LOB and Locking

Erik Darling notes a locking scenario specifically with LOB data:

To backtrack a little bit, part of what I wanted to show was that using order by can sometimes result in “more” blocking. I don’t mean more locks; what I mean is that when we need to order by Score, but we don’t have Score indexed in a useful way, the query will get hung up without showing any rows whatsoever.

Read the whole thing.