Qualifying old and new values for uncommitted updates

If a select query includes conditions on a column affected by an uncommitted update, and the query uses an index on the updated column, the query can examine both the old and new values for the column:

For select queries to avoid blocking when old and new values of uncommitted updates do not qualify, all of the following conditions must be met: