I have a query that takes 8-9 seconds to run and it uses the primary index on the bucket. I would really like to improve the speed of this query. I added this index CREATE INDEX bonsecours_arr_clientids_index ON deco_db_bonsecours(type,client_ids,(distinct (array v for v in client_ids end))) This …

Query replaces correct results with 'empty object's when using index

geraldss December 23, 2016, 7:52pm 4

Ok. Use EXPLAIN to verify that you are getting the most effective index usage.

Topic		Replies	Views
Index for a query with OR statement Couchbase Server n1ql , index	1	724	August 22, 2019
Why does N1QL not use my new index...? SQL++	5	1088	February 29, 2020
Query analyzer doesn't use index specified by "use index" statement SQL++	7	1381	June 12, 2021
Composite index not used by query SQL++ query , n1ql , index , array-query	2	1280	October 24, 2019
N1QL Index with an OR statement SQL++	13	3274	April 9, 2016