I have a query which looks for email address in the send_to key of my doc which looks like this.
SELECT META().id, c.* FROM Contacts c WHERE c._type = 'track_request' AND ARRAY_CONTAINS(c.send_to, 'firstname.lastname@example.org')
its a bit slow with close to 1 sec query time and the Advise recomends the folowing Index
CREATE INDEX adv_array_contains_send_to_eoko2dko3dko3google_com_type ON Contacts
), 'email@example.com')) WHERE _type
But i dont want to have an index specific for that address but for any address