I have the following document data model named tvSessions: “id”: “MEMCW:118:E81863521C47:2020-10-20” { "propCode": "MEMCW", "roomNumber": "118", "macAddress": "E81863521C47", "date": "2020-10-20", "source": "iptv", "lastReportedTime": 1603224693, "channels": [ {…

Yes the default order is ASC. Are you asking if the index is used for sorting? If so, no, index ordering has to match the ORDER BY for it to be used. ( MB-19917 ) But then your query with the given indices - using the RBO - would never use an index for ordering as it has to combine the indices t…

Performance of ORDER BY field with out an index

SQL++

system Closed May 28, 2024, 4:36pm 9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
ORDER BY is slow, have DESC in index SQL++ n1ql	2	1100	December 25, 2019
Couchbase 4.5 Order by diffrence in performnace for ASC and DESC even query covered Couchbase Server n1ql	61	6694	March 29, 2019
ORDER_BY ASC on index is much slower than ORDER_BY DESC Couchbase Lite query , n1ql , index	10	1596	October 7, 2019
ORDER BY Performance really slow SQL++	20	6735	December 4, 2017
Index for query with order by SQL++	11	7810	June 25, 2018

Performance of ORDER BY field with out an index

Related topics