Hello guys:
I'm a new with Neo4j. When taking a invesgation on neo4j cypher, i'm stumped by the TWO questions about INDEX:
Question1:
Neo4j index not work in WHERE condition with exists Cypher
Server version 4.3.1
...
Server version 4.3.1
1. Local create index
CREATE INDEX Supply_id_index IF NOT EXISTS FOR (l:SupplyPlan) ON (l.id);
2. execute explain
explain MATCH (shipment:`Shipment` {tenantId: '0804', type: 'Shipment'})
WHERE EXISTS {
MATCH (shi...
Hi, @Bennu
Which server version did you try in the above test?
I tried again in totally new 4.3.3 neo4j, with the default config and followed the steps above. It always can not hit the index in the second EXPLAIN(the first explain can hit, but after ...
So happy for your response @Bennu
If I run
profile match (a:Invoice)-[]->(b:InvoiceLine)
where a.id = "xxx" OR b.id = "xx"
return a,b;
The profile shows like
And if i run
profile match (a:Invoice)-[]->(b:InvoiceLine)
where a.id = "xxx" AND b.id ...
Yeah, actually i need a relation between the two node
profile match (a:Invoice)-[]->(b:InvoiceLine)
where a.id = "xxx" OR b.id = "xx"
return a,b;
Then it can not hit any index.
It is great to get help from you, but do you have any idea on Question 1...