If in my N1ql query , i want to extract millions of records in batches, then in my select query can i just use Offset and limit and keep on increasing the offset values after every batch pull. As the requirement is to extract unique records without any order. And also i want to ignore using order by as it impacts the performance.
Is my approach correct ?