Index on nested array inside a traditional array VS Index on a nested array inside object_pairs

[vsr1]

only one array index key per index.Index selection is based on predicate. Above query must use primary index.

Conditional append in a array from java sdk or N1QL

N1QL index selection is based on predicate. If query doesn’t have predicate only option is primary index. In above query will never choose idx01. It is not an ARRAY index (AS you don’t have DISTINCT or ALL) it just index that transforms OBJECT into ARRAY. CREATE INDEX idx01 ON ent_comms_tracking(ARRAY { v.name, v.val.data} FOR v IN object_pairs(`values`) END); SELECT ARRAY { v.name, v.val.data} FOR v IN object_pairs(`values`) END FROM ent_comms_tracking WHERE ARRAY { v.name, v.val.data} FOR …

I would recommend read through documentation first

Array Indexing | Couchbase Docs

Making the most of your Arrays... with N1QL Array Indexing

Check slides 43-60 https://www.slideshare.net/Couchbase/utilizing-arrays-modeling-indexing-and-querying