Hi, What would be the default sort order of a query if no “order by” statement is specified. All fields used in “where” clause is indexed using GSI. Currently we are getting consistent result and we assume that the result is ordered by the fields given in GSI. Please let us know whether our assu…

Default ordering of resultset using secondary index

nidhks July 12, 2018, 4:51am 7

@vsr1 Thanks for your support.

Topic		Replies	Views
Use GSI to speed up query, no effect SQL++ query , n1ql	10	2007	January 20, 2017
Index not hit on very simple ORDER BY N1QL query SQL++	3	1900	September 11, 2017
N1QL index data order SQL++ n1ql	2	1182	November 1, 2017
Index for query with order by SQL++	11	7805	June 25, 2018
Index Creation Possibility with Sorted Data based on Some Field Couchbase Server	6	792	October 11, 2021