I am new in the forums and more or less new to Neo4j. I have been working with it just a year. I am working with Neo4j 4.3.3.
I have a DB with a Full-Text Index and is working fine. But I would like to filter the results from the CALL to the index. I have done a little query as follows:
CALL db.index.fulltext.queryNodes("index_name","searchTerm~") YIELD node, score MATCH p=(m:Movie)--(a:Actor) WHERE id(a)=id(node) return a.content,score ORDER BY score DESC
It works. But...I think is not that good in performance, or maybe that it could improve.
The question is if I can create a subset of nodes where to apply the index, and not like I did, which is the other way around? Any idea How could I improve the filter?. I just show one relationship I have to do, from some others, so the final query could be heavy on that last part.
Thanks in advance!