[Docs RFC] Update docs for best practice using UUIDs

[billy-the-fish]

Noted that using UUIDs for partitioning/compression is problematic due to lack of sequential order and poor compression, and wishes for better support or guidance for such cases