I’m not sure how parallelism and concurrency in DBMS work. Here are the gaps in my understanding:
I understand that a transaction is made up of multiple instructions. And in my head, it makes sense that intra-transaction operations are parallelizable. I can imagine a quite a number of elementary situations where certain parts of the transaction do not depend on earlier parts, but I’m not sure that’s how it works.