Planner Hint for full text search indexes

Neo4j Graph Platform Cypher
,
1

I haven't found a definite answer on the topic so I wanted to ask can I use this:

USING INDEX t1:Transfer(eventName)

On a Full text search index, that I created like this:

CALL db.index.fulltext.createNodeIndex("SearchTransfersByEventName",["Transfer"],["eventName"],{ eventually_consistent: "true" });

I've been using planner hints for regular indexes without problem but I haven't figured out how to do it with search indexes so I wanted to know if it's possible at all. Thank you.

2

Currently fulltext index searches are initiated by a procedure call:
https://neo4j.com/docs/cypher-manual/current/administration/indexes-for-full-text-search/#administration-indexes-fulltext-search-query

As such there's no way to hint that a snippet of Cypher (that isn't doing a fulltext query call) should leverage the fulltext index.

This may change in some later minor or major release, as schema indexes and fulltext indexes become more integrated.

1 Like
3

Thank you! I thought that was the case but your answer is what I needed to confirm this.