I have a query below.
SELECT *
FROM c
WHERE
c.partition = "partition" AND
c.date BETWEEN "2020-01-01T00:00:00.000Z" AND "2020-12-31T23:59:59.999Z" AND
ARRAY_CONTAINS(["group_a", "group_b"], c.groups) AND
CONTAINS(c.name, "name", true) AND
c.deleted = null
ORDER BY
c.sequence DESC
I'd like to add composite indexes for this query.
What index is best for it?
