Hi, Currently I have created the following index in the bucket: CREATE INDEX index_one ON mt_bucket('a','b','c','d','e','f','g','h','i','type') USING GSI if I am using the following N1Q1 query: select * from mt_bucket USE INDEX (index_one USING GSI) where type=1 and a='a' and b='b' and c='c' and…

Couchbase Query Help

geraldss March 7, 2017, 3:02pm 2

Try using Couchbase 4.6. Cc @vsr1

Topic		Replies	Views
N1Ql query performance with IN clause SQL++	7	2290	January 6, 2020
Performance of single vs multiple n1ql queries for small data sets SQL++	6	2436	August 23, 2017
N1QL query is slow SQL++	8	3542	July 27, 2018
Why IN cluse is such peneltiy SQL++ query	1	1221	November 4, 2016
Can a n1ql query span multiple indexes? Couchbase Server	7	3359	October 28, 2018