My graph is defined as follows:
Edges: Objects may point to Attribute using :HAS_ATTRIBUTE relation type.
I have about 1M Object nodes and 1000 Attribute nodes. All of the properties are indexe...
Thank you. That makes sense now. I used it in other "inner join" kinda queries too, and it made things much faster because index was being used.
Of course, this particular trick did require knowledge of how query planner works. Any chance you have a ...
This is pure wizardry! The statement you provided executed in 2 secs, whereas my original MATCH query has not completed in like 5 mins.
I am providing query plans for both: