Re:Be Careful with UUID or GUID as Primary Keys
by sroussey on Friday June 09, 2017 @08:14PM
(#14525505)
Store, yes. But indexes don't do variable length (think about the index being a btree of binary values), so it gets expanded. UTF8 (utf8mb4) will thus expand to 4 bytes per character. And MySQL (pre 5.7) will stop you from making such stupid indices.
[ Parent
| on HN ]
There are no comments on this comment yet.