To summarize this in one line, "do not use UUIDs for primary keys".

Then what??? well ...

- UUIDs are great for replication and B2B.

- Add UUID as non-clustered index if needed.

- Use INT as a primary key. Period.