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
Using order by "param" DESC in N1QL is very slow (>5s) SQL++ query , n1ql	9	4326	April 26, 2017
N1ql does not use index for "order by" SQL++	30	6103	November 4, 2016
"Order by " making the N1QL Query slow SQL++ query , n1ql	2	732	October 10, 2018
Couchbase 6, N1SQL Order by desc is taking long time SQL++ query , java , n1ql	2	585	March 8, 2021
Couchbase Server CE 'get newest results' slow query Couchbase Server n1ql , index	8	2886	November 16, 2016

N1QL Query order by desc is slow

Related topics