Re: [Neo4j] [CYPHER] About Using Index clause

2014-06-29 Thread Sylvain Roussy
> > Many thanks to all ! It's clear now. >>> >> -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://gro

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-30 Thread Chris Leishman
The `USING INDEX` sub-clause is only for giving Neo4j a hint as to the index to use. Normally it will work that out for itself, and you shouldn't need to use it. In your case, you have two indexes: one on :Person(name) and the other :Person(job). To use either of those indexes in a query, the C

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-21 Thread Javad Karabi
Wes, could you elaborate on the following? "You can specify more than one, but you have to have a WHERE clause with an equality comparison on a property in the label index." On Monday, January 20, 2014 3:41:47 PM UTC-6, Wes Freeman wrote: > > The USING INDEX is for specifying which index(es) you

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-20 Thread Wes Freeman
The USING INDEX is for specifying which index(es) you want to use, when there is more than one choice. You can specify more than one, but you have to have a WHERE clause with an equality comparison on a property in the label index. There is also a USING SCAN :Person syntax, which specifies to scan

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-20 Thread Sylvain Roussy
> > Hi Michael, thank you for the answer, > But what is the USING INDEX clause use case then ? -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@goog

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-19 Thread Michael Hunger
For any index usage you need the label AND a property Only with the label, none of your two indexes will be used, but an internal label -> nodes index. Your index is only used if you do this: > MATCH (n:Person {name:"Philip"}) RETURN n.name, n.job or this > MATCH (n:Person) WHERE n.name = "Phi

[Neo4j] [CYPHER] About Using Index clause

2014-01-19 Thread Sylvain Roussy
Hi all, I'm trying the use of index with Cypher and I have a doubt about the USING INDEX clause usage : Consider three nodes : :Person {name:"Sylvain", job:"Developper"} :Person {name:"Philip", job:"Developper"} :Person {name:"Chritopher"} With two indexes : ON :Person(name) ONLINE ON :Pe