The five steps
- Insert and select 9 min
- The full predicate set 10 min
- Ordering 10 min
- Projection and paging 10 min
- Stop scanning 11 min
Store schemaless records and answer a small SQL-like read query over them: equality filters, the full comparison set, ordering with missing fields, projection and paging, and finally an index so the hot predicate stops scanning.