… but you can do them pretty efficient by using binary compression. Plus they should be stored in optimized sort order to… based part in UUID which has similar properties to auto_increment and which could be used to have values generated at same point in time physically local in BTREE index. This is actually the reason why UUID can do…

