Yeah sorry I had a brain fart and was thinking of stable pagination w/ compound sort+filter. It doesn't matter if id is UUID, sigh. Where date > y or (date eq

Yeah sorry I had a brain fart and was thinking of stable pagination w/ compound sort+filter. It doesn't matter if id is UUID, sigh. Where date > y or (date eq y and id > x) order by date, id This can't be completely fulfilled by an index. It'll have to sort/merge somevresults in memory, very CPU expensive. More examples here https://www.mixmax.com/engineering/api-paging-built-the-right-way https://www.mixmax.com/engineering/api-paging-built-the-righ...