News for hackers. Stuff that matters.

A comment on Be Careful with UUID or GUID as Primary Keys. Parent comment

Re:Be Careful with UUID or GUID as Primary Keys by Rapzid on Friday June 09, 2017 @03:44PM (#14523898)
Not all "UUID's" are distributed evenly. This is mentioned in the article.
[ Parent | on HN ]
Re:Be Careful with UUID or GUID as Primary Keys by mreftel on Friday June 09, 2017 @04:23PM (#14524227)
This was on Oracle, which lacks MS SQL's special handling of UUIDs (which speeds up indexes on UUID columns by using the bytes for the time stamp in UUIDv1/v2 as the high-order bytes - clever hack!). But sure, if you need UUIDs and your database has support for speeding them up, by all means, use that. I'd still avoid them given a choice, though.
[ Parent | on HN ]