Hi Killian, it would be helpful to see your exact index definitions, some example documents and to know a bit about the data distribution.
How many documents end up in one group here on average? COLLECT code=b.code, category_id=b.category_id INTO code_group What do you actually want to return here? "gfi_s" is not defined in the Gist: FOR a_tmp IN A ... RETURN gfi_s What is this for? The sub-query is limited to one result anyway. Is this for the case of no match or a missing attribute (gfi_s, see above)? FILTER LENGTH(a) == 1 Best, Simran -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to arangodb+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
