cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

The composite index not work

Fano
Node Link

Hello,
I faced a problem that composite index does not work (Neo4j community 3.5.9). First, I created some indexes named :Entity(entity_id), :Entity(entity_id,job_id),:Entity(job_id). Then, I profiled a query :

profile MATCH (n:Entity) WHERE n.entity_id="4234" AND n.job_id="5678" RETURN n LIMIT 200. 

The exeution plan is just as below.

The result shows that the composite index does not work. why not the execution engine choose the composite index(:Entity(entity_id,job_id)). Thanks for any input.

0 REPLIES 0
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online