Created index on array and count is slow. my index definition create index index_name_array on default(DISTINCT ARRAY name FOR name IN names END,names) Query explain Select count(1) from default where ANY name IN names SATISFIES name like ‘test%’ END [ { “plan”: { "#operator": “Sequence”, "…

Couchbase 4.5 indexscancounter missing for array indexing

ingenthr May 7, 2016, 5:58pm 2

I moved this to the proper category, just FYI.

Topic		Replies	Views
Create Secondary Index on Array SQL++ index	14	2886	October 27, 2017
How to properly index array field? Couchbase Server n1ql , index	3	1906	June 21, 2017
Index not working on array list SQL++	20	2307	July 20, 2017
N1ql index performance is different on same query SQL++ query , n1ql , index	3	811	March 30, 2020
I have a problem with ARRAY INDEXES Couchbase Server	24	2971	September 29, 2016