Hi, I’m using couchbase 6.5.1 and having issue for query using ‘order by’ My bucket contains 60 mio data and I have created index: CREATE INDEX idx-myBucket-01 ON myBucket(idnumber) WHERE (type_ = ‘xxx’) And below is my query: select * from myBucket where type_ = ‘xxx’ and idnumber <> ‘’ ord…

Try CREATE INDEX idx-myBucket-01 ON `myBucket` ( `idnumber` DESC ) WHERE ( `type_` = ‘xxx’) [image] Single Index to cover different sort fields (both asc & desc) SQL++ Hi @vsr1 I tried the below index, Query1 looks fine but Query 2,3,4 takes more time to get the resul…

N1QL Query order by desc is slow

SQL++

vsr1 December 10, 2020, 2:15pm 2

Try

CREATE INDEX idx-myBucket-01 ON `myBucket` ( `idnumber`  DESC ) 
WHERE ( `type_` = ‘xxx’)

1 Like

Topic		Replies	Views
Index for query with order by SQL++	11	7805	June 25, 2018
Couchbase 6, N1SQL Order by desc is taking long time SQL++ query , java , n1ql	2	618	March 8, 2021
Can't Use Index on Order By and Group By SQL++ query , n1ql , index	10	981	May 16, 2023
ORDER BY is slow, have DESC in index SQL++ n1ql	2	1094	December 25, 2019
Couchbase 4.5 Order by diffrence in performnace for ASC and DESC even query covered Couchbase Server n1ql	61	6691	March 29, 2019

N1QL Query order by desc is slow

Related topics