the following assessment in the Cypher Indexes and Constraints course seems to be wrong and might actually lead to a wrongful implementation and assumption of index usage.
As I understand non of the current available indexes would improve ...
Hi Omar, you can create a uniqueness constraint in your graph, which dictates that a specific property on a specific label will have a unique value in your graph.
CREATE CONSTRAINT YourUniqueConstraint IF NOT EXISTS
Hi, I faced a kind of similar issue with creating new nodes and merging relations on these nodes. Where one node will increasingly become a dense node.
The simplest solution for me was to switch the nodes in the merge query so from
Hi, you can access all nodes in the path via
`nodes(p) as nodes
List functions - Neo4j Cypher Manual
and then update all properties of the nodes with a map
SET - Neo4j Cypher Manual
with nodes(path) as nodes