query is executed as follows, in which I spot:
"_rows" : 478380,
"_db_hits" : 956760,
which is actually higher (= worse ??) than the original ..
{
"columns" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ],
"data" : [ [ "J70000", "J72191", 68 ], [ "J70000", "J73483", 67 ], [
"J70000", "J75683", 66 ] ],
"plan" : {
"args" : {
"returnItemNames" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ],
"_rows" : 3,
"_db_hits" : 0,
"symKeys" : [ "j1.jurt_id", "j2.jurt_id", "
INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372" ]
},
"dbHits" : 0,
"name" : "ColumnFilter",
"children" : [ {
"args" : {
"limit" : "Literal(3)",
"orderBy" : [ "SortItem(Cached(
INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372 of type
Integer),false)" ],
"_rows" : 3,
"_db_hits" : 0
},
"dbHits" : 0,
"name" : "Top",
"children" : [ {
"args" : {
"keys" : [ "Cached(j1.jurt_id of type Any)", "Cached(j2.jurt_id
of type Any)" ],
"_rows" : 9992,
"aggregates" : [ "(
INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372,Count(t))" ],
"_db_hits" : 0
},
"dbHits" : 0,
"name" : "EagerAggregation",
"children" : [ {
"args" : {
"_rows" : 478380,
"_db_hits" : 956760,
"exprKeys" : [ "j1.jurt_id", "j2.jurt_id" ],
"symKeys" : [ "j1", "t", " UNNAMED79", "j2", " UNNAMED62" ]
},
"dbHits" : 956760,
"name" : "Extract",
"children" : [ {
"args" : {
"_rows" : 478380,
"_db_hits" : 0,
"pred" : "NOT(j2 == j1)"
},
"dbHits" : 0,
"name" : "Filter",
"children" : [ {
"args" : {
"g" : "(j1)-[' UNNAMED62']-(t),(j2)-[' UNNAMED79']-(t)",
"_rows" : 478380,
"_db_hits" : 0
},
"dbHits" : 0,
"name" : "SimplePatternMatcher",
"children" : [ {
"args" : {
"identifiers" : [ "j1" ],
"query" : "{jurtid}",
"producer" : "SchemaIndex",
"_rows" : 1,
"property" : "jurt_id",
"label" : "jurt",
"_db_hits" : 0,
"identifier" : "j1"
},
"dbHits" : 0,
"name" : "SchemaIndex",
"children" : [ ],
"rows" : 1
} ],
"rows" : 478380
} ],
"rows" : 478380
} ],
"rows" : 478380
} ],
"rows" : 9992
} ],
"rows" : 3
} ],
"rows" : 3
}
}
--
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.
