Primary Index vs Unique index

I've seen a few posts about sequential id vs UUID on the forum, but nothing related to a combination of both in one table.

Is there any difference in performance of a PRIMARY index field ( ie: the default id field that exists in every table) vs a user created field of type UUID that is set as UNIQUE INDEX? ( As seen in the screenshot )

This question arises because I have many tables in my DB that have the default id field of auto incrementing integer that I want to hide from my front-end by creating a UUID column that will be used as my primary key for queries / addons, etc.

5 replies