Ordering in select statement

SQL++
1

Does couchbase ensures ordering of records without ORDER BY clause ?

For eg If I run following queries in sequence ,
SELECT TestBucket1.* FROM TestBucket1 WHERE type=“individual” OFFSET 0 LIMIT 10000;
SELECT TestBucket1.* FROM TestBucket1 WHERE type=“individual” OFFSET 10000 LIMIT 10000;
SELECT TestBucket1.* FROM TestBucket1 WHERE type=“individual” OFFSET 20000 LIMIT 10000;

Will it always give me distinct set of output everytime?

2

With out ORDER BY Clause results might not be ordered.
Based on query and index Optimizer will try to use Index order when possible.

It looks like you might me interested.


3

Thanks .
Here just wanted to clarify , whether sequence of results will always be same or it might differ .

4

If use order by those always same. if no order by those are not guaranteed.