Imagine two insert operations that would violate unique constraint happen in exact time. How they keep those records unique without affecting performance? If they process one insert operation at a time, that would be slowing all other insert. Source link