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.