I have a query like
SELECT
a.id,
ARRAY {b.foo} for bItem IN b END
FROM bucket a
NEST bucket b ON a.id=b.id AND b.type='B'
WHERE a.type='A'
If I use JOIN
instead of NEST
the query used covering index , But in NEST
it fetches b
too
How can I change query or add index to cover NEST
?