| +DirectedRelationshipIndexSeek | TEXT INDEX (person)->(friend) WHERE metIn = $autostring_0 | 1 | 1 | 2 | 120 | 2/0 | 0. Total database accesses: 2, total allocated memory: 184 Relationship TEXT index | +NodeIndexSeek | TEXT INDEX person:Person(surname) WHERE surname = $autostring_0 | 1 | 1 | 2 | 120 | 2/0 | 0.446 | Fused in Pipeline 0 | Total database accesses: 2, total allocated memory: 184 Node TEXT index | +DirectedRelationshipIndexSeek | RANGE INDEX (person)->(friend) WHERE since = $autoint_0 | 1 | 1 | 2 | 120 | 2/1 | 0.413 | Fused in Pipeline 0 | | +ProduceResults | person, friend | 1 | 1 | 0 | | | | | Total database accesses: 2, total allocated memory: 184 Relationship RANGE index example | +NodeIndexSeek | RANGE INDEX person:Person(firstname) WHERE firstname = $autostring_0 | 1 | 1 | 2 | 120 | 2/1 | 0.635 | Fused in Pipeline 0 | | +ProduceResults | person | 1 | 1 | 0 | | | | | Total database accesses: 23, total allocated memory: 184 Node RANGE index example | Operator | Details | Estimated Rows | Rows | DB Hits | Memory (Bytes) | Page Cache Hits/Misses | Time (ms) | Pipeline | Spatial bounding box searches (single-property index) Spatial distance searches (single-property index) Substring search using CONTAINS (composite index)Įxistence check using IS NOT NULL (single-property index)Įxistence check using IS NOT NULL (composite index) Substring search using CONTAINS (single-property index) Suffix search using ENDS WITH (composite index) Suffix search using ENDS WITH (single-property index) Prefix search using STARTS WITH (composite index) To learn more about cypher and its syntax, you. This will query the database for all nodes. MATCH (n) RETURN distinct labels(n), count(). Prefix search using STARTS WITH (single-property index) Cypher is a declarative query language that provides a visual and logical way to match node and relationships. Lets do some queries to familiarize ourselves with the data. List membership check using IN (composite index) List membership check using IN (single-property index) Multiple range comparisons using WHERE (composite index) Multiple range comparisons using WHERE (single-property index) Range comparisons using WHERE (composite index) Range comparisons using WHERE (single-property index)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |