Hi, I’m using CB 4.5.1-2844 Enterprise Edition and trying to compare 2 approaches to query my data below: Case: We have groups and users, which a group have multiple users and a user will belong to multiple groups. Will need to list by 2 ways, (1) by group, (2) by user Approach 1: Store the i…

N1ql array index performance

atom_yang November 30, 2016, 10:42am 4

I think N1QL can not solve this problem.
and FYI

Topic		Replies	Views
N1ql index performance is different on same query SQL++ query , n1ql , index	3	814	March 30, 2020
Performance of single vs multiple n1ql queries for small data sets SQL++	6	2442	August 23, 2017
I have some doubt about N1ql SQL++	8	3043	July 28, 2015
How to speedup n1ql query - what to scale (index, query, data)? Couchbase Server n1ql	1	1755	May 8, 2016
Can N1QL query to stored index or create indexes? SQL++	1	2044	June 21, 2014