Document schema looks like below { "count": 3, "member_id": "member_0_2", "segments": ["segment_0", "segment_1", "segment_2"] } Covered array index that: CREATE INDEX `segments_idx` ON `sample`(`member_id`,(distinct (array (`segment`) for `segment` in `segments` end))) WHERE (`count` > 0) Q…

Not able to avoid bucket scan while using covered array index

abhishek January 22, 2020, 9:29am 2

Topic		Replies	Views
Index is not covered when array is used in where clause - Couchbase 4.5 SQL++ index	4	895	June 30, 2019
Covering index for nested array SQL++ index	10	2179	June 15, 2019
Covering array index not avoiding FETCH Couchbase Server query , n1ql , index , arrays , array-query	8	825	December 15, 2022
Covering array index with arbitrary predicates SQL++ index , arrays , array-query	4	1865	July 5, 2019
Couchbase 4.5 indexscancounter missing for array indexing SQL++	13	3212	May 14, 2016