select _id,name,url,tags,status,createdAt from content where _type=“UserAsset” order by createdAt desc limit 10 “UserAsset” has 3lakhs document and I am using “Enterprise Edition 5.5.2 build 3733 ‧ IPv4” couchbase. still the above query is taking 10sec to execute. Is there any alternate way to o…

"Order by " making the N1QL Query slow

sanjay.p October 10, 2018, 1:50pm 3

Its working for UserAsset now.
Thanks

Topic		Replies	Views
N1QL is very slow with "order by" clause SQL++ n1ql	4	2319	September 11, 2016
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	5644	January 29, 2018
Issue in Order by in N1QL query SQL++ java	4	1649	March 13, 2018