[vanviegen]

But that would be slow, even with an index, as compared to using a clustered primary key. Especially when your data doesn't fit in ram.

[endisneigh]

Sure, already mentioned UUID’s being slow. There are trade offs