Re: [Neo4j] Help in making the query more efficient

Can you share the current query plan that you get when you prefix your query with PROFILE Also the size and structure of your datastore and the output of :schema to list existing indexes and constraints. > Am 22.08.2016 um 21:28 schrieb Divya Saxena : > > Hi, > Can someone help me in making th

[Neo4j] Help in making the query more efficient

Hi, Can someone help me in making the following query more efficient. MATCH n=(node1:Node1)<-[:RELATION1]-(node2:Node2) WHERE node2.entity2 IN ['ABC','LMN','PQR'] AND node1.entity1 IN ['XYZ'] WITH COUNT(n) as nCount MATCH (node11:Node1)<-[:RELATION1]-(node21:Node2) WHERE node2.entity2 IN ['ABC',