How to index relationship properties in Neo4J in an easy way

Question

I want to index the existing relationship properties in Neo4J (2.0.1) and also to set up automatic indexing for the ones that will appear in the future.

I found out that it's possible to do that in Neo4J documentation through the legacy auto-indexing as well as the examples of some Java code.

However, as I'm neither an expert in Java, nor want to use "legacy" functionality, I wanted to ask you if there is an easy way to index relationships on a specific property using Cypher command or any other way (rest API?) that wouldn't involve me having to write some Java program and run it (I don't know how to do that).

Thank you for your help!

score 4 · Answer 1 · edited May 23 '17 at 12:34

4

My original answer was wrong. Editing so that it doesn't generate confusion to others looking for a solution.

Please refer to Relationship Labels and Index in Neo4J a for correct answer, as @deemeetree pointed out in the comments.

edited May 23 '17 at 12:34

Community

1
1

answered Mar 15 '14 at 13:58

albertoperdomo

1,941
12
14

2

Does that actually work? My understanding is that this syntax only works for nodes not for relationships. I just tried something similar and it says it created the index but it isn't actually using it in queries. I think in your example you've actually created an index on nodes labelled WATCHED. – Damon Horrell Mar 17 '14 at 01:37
Exactly. This is a wrong answer. Check this out: http://stackoverflow.com/questions/22437106/relationship-labels-and-index-in-neo4j/22444108 – Aerodynamika Mar 17 '14 at 02:06
Yes, I was wrong, @deemeetree. I'm editing the answer to reflect that it's wrong. If you think I should remove it just tell me. – albertoperdomo Mar 17 '14 at 15:34

score 3 · Answer 2 · answered Sep 01 '21 at 17:42

Since Neo4j 4.3 (released June 17, 2021), creating relationship property indexes can be done directly with Cypher, as discussed on the Neo4j blog and the 4.3 release notes.

Example from the blog:

CREATE INDEX officerRelationshipProperty
FOR ()-[r:OFFICER_OF]-()
ON (r.role);

score -3 · Answer 3 · answered Jul 10 '20 at 19:03

-3

You can't do indexing on relationship. Indexing is done only on nodes.

answered Jul 10 '20 at 19:03

Pankaj Katkar

23
4

1

You obviously don't know Neo4J – Aerodynamika Jul 11 '20 at 13:19
#Aerodynamika can you explain broo? – Pankaj Katkar Jul 12 '20 at 14:26
Relationship indexes were introduced in Neo4j 4.3 https://neo4j.com/product/neo4j-graph-database/whats-new-in-neo4j-4-3/ – Savva Sergey Feb 08 '23 at 09:15

How to index relationship properties in Neo4J in an easy way

3 Answers3