Create index on Relationship property

[rajeevprasanna]

I read somewhere that Neo4j latest version supports indexing on relationship properties.

Can someone guide me how can we create index on relationship property?
please share syntax of it and limitations

[dominicvivek06 · Accepted solution]

Neo4j currently support Full Text Index on Relationships types and properties.

db.index.fulltext.createRelationshipIndex

Please refer -

Neo4j Graph Database Platform

Indexes for full-text search - Neo4j Cypher Manual

This section describes how to use full-text indexes, to enable full-text search.

[rajeevprasanna]

If i created index on relationship property, will queries use those indexes implicitly?

I have query like below where querying is done on relationship property.

optional match (u)-[r:Relationship]-() where r.id = 123
 	return u

How can this be optimised with full index search or any other way?

[rajeevprasanna]

any answers on this?

[clem]

Try experimenting with the query with and without the index.

Then, use the PROFILE or EXPLAIN commands to see if the index helps or hurts.

My guess is that it would help.

[rajeevprasanna]

I need to query index relationship directly to use it. thankx

[dominicvivek06]

CALL db.index.fulltext.createRelationshipIndex("Rel_index_name", ["Relationship_Name"], ["Relationship_Property_Name"])

CALL db.index.fulltext.queryRelationships("Rel_index_name", "<search value>") YIELD relationship,score

Neo4j Graph Database Platform

Procedures - Operations Manual

[dominicvivek06]

Hi @rajeevprasanna ,

Neo4j 4.3 has now released with Index on Relationship properties.

Refer -> Indexes for search performance - Neo4j Cypher Manual

A simple demo -> Neo4j 4.3 Relationship Index – Dominic KUMAR's blog