Hi, I’m using couchbase server 4.5.0-2601 and found out that the N1QL is very slow with order by clause regardless I already create index for it. Detail: I have 130k data on “default” database I created index for “postingDate” : Create index pd_idx on default(postingDate) The query without “orde…

N1QL is very slow with "order by" clause

tinygipxy September 11, 2016, 2:48am 5

I think this is bug of 4.5, anybody know, does this work on 4.1 ?

Topic		Replies	Views
N1ql does not use index for "order by" SQL++	30	6273	November 4, 2016
Couchbase 6, N1SQL Order by desc is taking long time SQL++ query , java , n1ql	2	616	March 8, 2021
Paginating with n1ql SQL++	24	5645	January 29, 2018
"Order by " making the N1QL Query slow SQL++ query , n1ql	2	769	October 10, 2018
N1QL is not ordering the query Couchbase Server query	2	629	March 5, 2020