2 ms·
I hoped this had a toy implementation of sql indices, but it looks like that's not the case: it just sorts the whole table on the fly on an ORDER BY.
by curtisblaine 2y ago
I hoped this had a toy implementation of sql indices, but it looks like that's not the case: it just sorts the whole table on the fly on an ORDER BY.
- aboodman 2y agoI mean that basically in an implementation of indexes. Move the on-the-fly sorts to behind a command, then change the insert/delete code to maintain them, and voila - indexes.
- curtisblaine 2y agoAren't indexes a static, pre-calculated way to avoid in-memory sorting on the fly?