Use when you need all rows you read to remain stable for the duration of your unit of work — for example, when you read data to make a decision and then update based on that decision. RS holds locks on all accessed rows until COMMIT. Be careful: if you read 10,000 rows, you hold 10,000 locks.