Question
Read consistency versus locking: how do ordinary queries and DML differ?
Answer
Ordinary queries reconstruct committed data from undo and generally do not lock rows. DML locks changed rows until transaction end. Use consistent reads for reporting; use explicit row locks when a later update needs protection.