So when public APIs use uuidv4 to fetch item, those uuidv4 still need to be indexed...
Right, but that's one lookup vs the many joins you're probably doing internally