Haripriya Naidu digs into a few scenarios:
When RCSI is enabled, I’d like to discuss three scenarios:
- UPDATE is in progress, and SELECT starts to run.
Where does SELECT read from?- SELECT runs, and there are no concurrent operations or uncommitted transactions. Where does SELECT read from?
- SELECT is running, and now an UPDATE starts to run concurrently. What happens to SELECT that is in progress? What about the UPDATE that started? Does it wait for SELECT to finish?
Click through to see what happens during each of these scenarios.