take a note:
When multiple processes are concurrently attempting to update the same block, the block is said to be hot. Hot blocks don’t always occur in indexes, but most of them do.
Reverse Key Indexes and Global Partitioned Indexes alleviate this problem.