Actually if the committed value was 0 and it is going to be updated to 10000000, then when you select the row, you will get 0.

You will get the most latest Committed value. That is the true value. This will reduce Wait for resource and lessens the load on the server.