Good question, perhaps it decided that the index selectivity was too low as it is a boolean index?
You can force it and see how it changes: > explain > match (p:Place) using index p:Place(_geocoded) > where p._geocoded = "true" > return count(p); > Am 15.04.2015 um 22:33 schrieb Clark Richey <[email protected]>: > > Hello, > When I run EXPLAIN on this query I can see that the index isn’t being used. > See below. However, when I execute the schema command I can see that that > index is on-line. (ON :Place(_geocoded) ONLINE) > > Why isn’t the query performing a nodeIndexSeek? > > > > > neo4j-sh (?)$ explain match (p:Place)where p._geocoded = "true" return > count(p); > +--------------------------------------------+ > | No data returned, and nothing was changed. | > +--------------------------------------------+ > 10 ms > > Compiler CYPHER 2.2 > > Planner COST > > EagerAggregation > | > +Filter > | > +NodeByLabelScan > > +------------------+---------------+-------------+--------------------------------+ > | Operator | EstimatedRows | Identifiers | > Other | > +------------------+---------------+-------------+--------------------------------+ > | EagerAggregation | 1592 | count(p) | > | > | Filter | 2535411 | p | p._geocoded == { > AUTOSTRING0} | > | NodeByLabelScan | 7606234 | p | > :Place | > +------------------+---------------+-------------+--------------------------------+ > > > > --- > > > <fg-logo.png> > > > Clark D. Richey, Jr > CHIEF TECHNOLOGY OFFICER > 240.252.7507 > [email protected] <mailto:[email protected]> > WWW.FACTGEM.COM <http://www.factgem.com/> > Clark Richey > [email protected] <mailto:[email protected]> > > > > > -- > 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 [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
