How to Use SubQuery in In Clause?

Neo4j: Can Cypher query use index automatic in where clause to filter the result?

• I found it too slow when using where clause, so suspect it does not use lucene index ,why, I know the start clause can use index ,why where can't?

• Answer:

  No, not at the moment, though that's been announced as being in the plans. I frequently find that if I feel I need to use indexes as anything other than a place to start pattern matching, though, what I really need to do is rethink my query or graph structure. There's also a possibility your scenario can be handled using additional start clauses, which can each use an index lookup. For instance, if your query returns a a number of nodes that you then narrow down to a smaller number, which you then want to connect to some other nodes: START possible=node:node_auto_index({possibles_query}) WHERE possible-[:won]->() WITH possible START prize=node:node_auto_index({other_query}) CREATE possible-[:owns]->prize Note: that will connect every possible (remaining after the WHERE clause is applied) to every prize.