Hello there, Implementing keyset pagination with multiple keys and an index is easy when all the keys have the same ordering (ascending or descending). It is just a matter of using JSON arrays comparison in N1QL selects where clauses. It performs a nice lexicographic comparison, and the index is us…

Keyset pagination with N1QL, an index with multiple keys and per-key sort order

Hawkeye January 13, 2023, 4:38pm 5

Oh my goodness, but you are correct!
In the most complex question, the most silly error on my side.
BIG BIG THANKS!

Topic		Replies	Views
Access to index without SQL++ query SQL++ query , n1ql	58	312	May 19, 2025
Index for query SQL++ n1ql	4	1759	August 26, 2016
Index for query with order by SQL++	11	7788	June 25, 2018
Advice on creating an index for good performance SQL++	7	1509	January 19, 2022
Index not hit on very simple ORDER BY N1QL query SQL++	3	1896	September 11, 2017