Assert whether indices cause significant contention on write requests

The UUID property has a unique constraint. I suspect this property will be set for all graph elements (edges and vertices).
It would perhaps be better to only use the index on core vertices, edges.
Additionally we should check whether the segment path properties and url link are also affected.

Testing this could be simple. It may be possible to remove the uniqueness flag or the index for those indices in the odb studio.

Start by reviewing the UUID unique constraint and the indices for core vertices, edges, segment path properties, and URL links. Use ODB Studio to compare write behavior with the uniqueness flag or relevant indices removed, and document whether those indices cause significant contention.

Written by the indexing model from the issue text.