cancel
Showing results for 
Search instead for 
Did you mean: 

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

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.