3 ms·
Yep the Seek Method for pagination as suggested there would cause you to be sorting by UUID. SELECT uuid FROM t where filterable_field > $whatever and uuid
by whateveracct 9y ago
Yep the Seek Method for pagination as suggested there would cause you to be sorting by UUID.
SELECT uuid FROM t where filterable_field > $whatever and uuid > $lastSeen limit $pageSize
with a covering index on (filterable_field, uuid)