It's just not true. If you are working in a transaction with higher isolation level than read committed, the locks will hold until the transaction is committed.
The whole point of using an ACID RDBMS is knowing you're dealing with accurate data and not guesses or estimates.
It's just not true. If you are working in a transaction with higher isolation level than read committed, the locks will hold until the transaction is committed.
The whole point of using an ACID RDBMS is knowing you're dealing with accurate data and not guesses or estimates.