This can perform better than paging based on OFFSET. For more information, see: - http://use-the-index-luke.com/no-offset - https://blog.jooq.org/2013/10/26/faster-sql-paging-with-jooq-using-the-seek-method/