Question

When a transaction is rolled back under timestamp ordering. It is assigned a new timestamp. Why can it not simply keep its old timestamp?

Answer 1

Answer:

hey mate here is your answer..

hope it's helpful for you..

follow me

Answer 2

Answer:

A transaction has rolled back means some other transaction has made the changes in the data which it was supposed to do. Now if it returns with the same timestamp then it will rollback again for the same previous reason and this will continue endlessly hence it is assigned a new timestamp value

Explanation:

source : Quora