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)
