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 |
+------------------+---------------+-------------+--------------------------------+
---
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]
--
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.
