4 ms·

Well I think this achieves minimal rewrites, but you do lose a bit on indexing. You can't retrieve by numeric position index for example. But reproducing the or

Well I think this achieves minimal rewrites, but you do lose a bit on indexing. You can't retrieve by numeric position index for example. But reproducing the order is just a matter of starting from the head (where PrecededById is null) or from any point and then repeatedly selecting the entry whose PrecededById = the current ID.

grzm 9y ago
That's more than a bit on indexing. Following a linked list through repeated selections is not nearly as efficient as an index scan.
- rdiddly 9y ago
  Yeah that's true. Oh well, fractions it is then!