7 ms·
It needs to store rows in order to support indexes, so that a row could be found without having to scan the whole table, and that's exactly what B-Trees let you
by gtrubetskoy 13y ago
It needs to store rows in order to support indexes, so that a row could be found without having to scan the whole table, and that's exactly what B-Trees let you do, and also add or remove rows without having to rewrite the whole table, but only affected blocks.
- Flow 13y agoWhat you say, isn't that more or less exactly what I wrote?