Creating a Comprehensive Fulltext Index in Neo4j AuraDB

Neo4j Graph Platform Cypher
1

I want to create a Fulltext index in Neo4j AuraDB for all nodes and all properties.

The example shows how to create an index for specific nodes and their properties, but I want to be able to search across all nodes and all their properties.

How should I modify and use the following Cypher query to meet this requirement?

CREATE FULLTEXT INDEX namesAndTeams FOR (n:Employee|Manager) ON EACH [n.name, n.team]

Would you like me to provide a possible solution or explanation for this query modification?

2

As far as labels are concerned, you can add a specific label like :FullText on all nodes. For properties, I think you have no other way but to list all text properties you want to index.

But depending on the size of you db, a fulltext index on all text properties can get very big and costly in terms of updating time, so you should really make sure RANGE or TEXT indexes are not sufficient for the kind of search you intend to make

1 Like