Azure SQL Managed Instance. If I am updating a temp table, and joining to another table or tables, do the joined tables also get locked, even though the update statement is only updating the temp table? I'm trying to figure out why this query would cause blocking.
UPDATE M SET M.MatchWgt = M.MatchWgt + 80 FROM #MatchPossibles M JOIN LostHD L ON M.PossibleMatchID = L.ID JOIN LostHD L1 ON L1.PhoneNumber = L.PhoneNumber AND L1.ID = M.IDtoMatch;
Should I be using the
NOLOCK hint on the "read only" tables?