I am having an issue with N1QL query with GROUP BY clause. This query is taking around 30+ seconds and I need some help to optimize it. Currently there are no indexes being used by this query. I am using Couchbase 6.0.1 version. Please see below sample data and query. QUERY: SELECT sr.attrName,sr…

Issue with N1QL query with GROUP BY

cb360 October 18, 2019, 4:59pm 2

Any pointers on this query? Appreciate if someone could chime in…thank you

Topic		Replies	Views
Queries take minutes with N1QL SQL++ n1ql	4	1114	October 10, 2017
Couchbase N1QL Group by issue SQL++ query , n1ql	3	1750	June 30, 2017
N1ql Group By on 2 attributes Couchbase Server n1ql	1	524	March 8, 2021
GROUP BY performance SQL++ java , n1ql	13	3316	July 13, 2017
N1QL query is slow SQL++	8	3542	July 27, 2018