When using uuid, mysql index cannot be used. Is there any solution?

Question

For example:

https://www.youtube.com/watch?v=JuoqE2lpRUM

The self-increasing ID is not used, presumably to protect privacy, but how can this design improve retrieval efficiency?

Answer 1

There is no conflict between protecting privacy and using self-increasing IDs. Just use a reversible encryption method on the front end and back end