Indexes required to make this query fast

Neo4j Graph Platform Cypher
1

Hello
Suppose I have the following query:

MATCH(b:A)
WITH b.field1 as field1, MAX(b.field2) as field2
WHERE b.field1 = field1
MATCH (b)
WHERE b.field1 = field1 AND b.field2 = field2
RETURN b

This query works fine and returns the data I want but the only problem is that it is very slow (2 seconds to return) once my graph has 200k Nodes of type A

What indexes do I need to make it fast?

I have the following:

CREATE INDEX ON : A( field1, field2)
CREATE INDEX ON : A( field1)
2

You forgot to add :A to your 2nd match.

So the indexes don't trigger.