Why is it better to use UUIDs to store unique identifier values?

Question

Why is it better to use a UUID to store unique id values? What are the benefits?

Answer 1

Two reasons.

The regular identifier is unique only inside your table inside your system. If you ever need to integrate systems, there will be a conflict. UUID is guaranteed to be unique across systems.

The second reason is that often you don’t want people to know how many records you have on your system. If you have an identifier with 1,2,3,4,5,6, then someone can easily determine how big or small your system is.

Answer 2

Here ya go:

Advantages and disadvantages of GUID / UUID database keys