3 ms·
It wont't be a new kind of index. It would be a new interpretation of OFFSET and LIMIT, which would ignore deleted rows.
by ngrilly 9y ago
It wont't be a new kind of index. It would be a new interpretation of OFFSET and LIMIT, which would ignore deleted rows.
- thriftwy 9y agoWhy would it? It will be rebuilt when a row is deleted or even marked deleted. If we have an pagination index over (topicId, deleted) on postTime asc.