The new index types in Neo4j 4.3 work in much the same way as Node and Node Property indexes do – they enable you to quickly look up where there are references to a particular Relationship Type in the graph (i.e. which Nodes are connected by the relationship). By Stu Moore, Product Manager.
The article takes a look at:
- What are Relationship / Property indexes, and when do you use them?
- Side note on the use of indexes
- Ok, that’s great! give me an example?
- The query
- How do you create the index on the role?
- Now that you mention it, how much faster is PIPELINED?
- Troubleshooting with EXPLAIN plan logging
Adding Indexes does need to be done with some thought because they increase the write workload – creates and updates on the index when new data is written to the database. Indexes may not benefit your queries when the majority of nodes have the same relationship type or there is only a single relationship type – same goes for relationship properties. Good read!
[Read More]