Execution plan operators

AllNodesScan

Reads all nodes from the node store.

Anti

Tests for the absence of a pattern.

AntiSemiApply

Performs a nested loop. Tests for the absence of a pattern predicate.

Apply

Performs a nested loop. Yields rows from both the left-hand and right-hand side operators.

Argument

Indicates the variable to be used as an argument to the right-hand side of an Apply operator.

AssertSameNode

Ensures that no node property uniqueness constraints are violated.

AssertSameRelationship

Ensures that no relationship property uniqueness constraints are violated.

AssertingMultiNodeIndexSeek

Used to ensure that no property uniqueness constraints are violated.

CacheProperties

Reads node or relationship properties and caches them.

CartesianProduct

Produces a cartesian product of the inputs from the left-hand and right-hand operators.

Create

Creates nodes and relationships.

CreateIndex

Creates an index for either nodes or relationships.

CreateConstraint

Creates a constraint for either nodes or relationships.

Delete

Deletes a node or relationship.

DetachDelete

Deletes a node and its relationships.

DirectedAllRelationshipsScan

Fetches all relationships and their start and end nodes in the database.

DirectedRelationshipByIdSeek

Reads one or more relationships by id from the relationship store.

DirectedRelationshipIndexContainsScan

Examines all values stored in an index, searching for entries containing a specific string; for example, in queries including CONTAINS.

DirectedRelationshipIndexEndsWithScan

Examines all values stored in an index, searching for entries ending in a specific string; for example, in queries containing ENDS WITH.

DirectedRelationshipIndexScan

Examines all values stored in an index, returning all relationships and their start and end nodes with a particular relationship type and a specified property.

DirectedRelationshipIndexSeek

Finds relationships and their start and end nodes using an index seek.

DirectedRelationshipIndexSeekByRange

Finds relationships and their start and end nodes using an index seek where the value of the property matches a given prefix string.

DirectedRelationshipTypeScan

Fetches all relationships and their start and end nodes with a specific type from the relationship type index.

DirectedUnionRelationshipTypesScan

Fetches all relationships and their start and end nodes with at least one of the provided types from the relationship type index.

Distinct

Drops duplicate rows from the incoming stream of rows.

DoNothingIfExists(CONSTRAINT)

Checks if a constraint already exists, if it does then it stops the execution, if not it continues.

DoNothingIfExists(INDEX)

Checks if an index already exists, if it does then it stops the execution, if not it continues.

DropConstraint

Drops a constraint using its name.

DropIndex

Drops an index using its name.

Eager

For isolation purposes, Eager ensures that operations affecting subsequent operations are executed fully for the whole dataset before continuing execution.

EagerAggregation

Evaluates a grouping expression.

EmptyResult

Eagerly loads all incoming data and discards it.

EmptyRow

Returns a single row with no columns.

ExhaustiveLimit

The ExhaustiveLimit operator is similar to the Limit operator, but always exhausts the input. Used when combining LIMIT and updates.

Expand(All)

Traverses incoming or outgoing relationships from a given node.

Expand(Into)

Finds all relationships between two nodes.

Filter

Filters each row coming from the child operator, only passing through rows that evaluate the predicates to true.

Foreach

Performs a nested loop. Yields rows from the left-hand operator and discards rows from the right-hand operator.

IntersectionNodeByLabelsScan

Fetches all nodes that have all of the provided labels from the node label index.

LetAntiSemiApply

Performs a nested loop. Tests for the absence of a pattern predicate in queries containing multiple pattern predicates.

LetSelectOrAntiSemiApply

Performs a nested loop. Tests for the absence of a pattern predicate that is combined with other predicates.

LetSelectOrSemiApply

Performs a nested loop. Tests for the presence of a pattern predicate that is combined with other predicates.

LetSemiApply

Performs a nested loop. Tests for the presence of a pattern predicate in queries containing multiple pattern predicates.

Limit

Returns the first n rows from the incoming input.

LoadCSV

Loads data from a CSV source into the query.

LockingMerge

Similar to the Merge operator but will lock the start and end node when creating a relationship if necessary.

Merge

The Merge operator will either read or create nodes and/or relationships.

MultiNodeIndexSeek

Finds nodes using multiple index seeks.

NodeByElementIdSeek

Reads one or more nodes by ID from the node store, specified via the function elementId().

NodeByIdSeek

Reads one or more nodes by ID from the node store, specified via the function id().

NodeByLabelScan

Fetches all nodes with a specific label from the node label index.

NodeCountFromCountStore

Uses the count store to answer questions about node counts.

NodeHashJoin

Executes a hash join on node ID.

NodeIndexContainsScan

Examines all values stored in an index, searching for entries containing a specific string.

NodeIndexEndsWithScan

Examines all values stored in an index, searching for entries ending in a specific string.

NodeIndexScan

Examines all values stored in an index, returning all nodes with a particular label with a specified property.

NodeIndexSeek

Finds nodes using an index seek.

NodeIndexSeekByRange

Finds nodes using an index seek where the value of the property matches the given prefix string.

NodeLeftOuterHashJoin

Executes a left outer hash join.

NodeRightOuterHashJoin

Executes a right outer hash join.

NodeUniqueIndexSeek

Finds nodes using an index seek within a unique index.

NodeUniqueIndexSeekByRange

Finds nodes using an index seek within a unique index where the value of the property matches the given prefix string.

Optional

Yields a single row with all columns set to null if no data is returned by its source.

OptionalExpand(All)

Traverses relationships from a given node, producing a single row with the relationship and end node set to null if the predicates are not fulfilled.

OptionalExpand(Into)

Traverses all relationships between two nodes, producing a single row with the relationship and end node set to null if no matching relationships are found (the start node is the node with the smallest degree).

OrderedAggregation

Like EagerAggregation but relies on the ordering of incoming rows. Is not eager.

OrderedDistinct

Like Distinct but relies on the ordering of incoming rows.

PartialSort

Sorts a row by multiple columns if there is already an ordering.

PartialTop

Returns the first n rows sorted by multiple columns if there is already an ordering.

ProcedureCall

Calls a procedure.

ProduceResults

Prepares the result so that it is consumable by the user.

ProjectEndpoints

Projects the start and end node of a relationship.

Projection

Evaluates a set of expressions, producing a row with the results thereof.

RelationshipCountFromCountStore

Uses the count store to answer questions about relationship counts.

RemoveLabels

Deletes labels from a node.

RollUpApply

Performs a nested loop. Executes a pattern expression or pattern comprehension.

SelectOrAntiSemiApply

Performs a nested loop. Tests for the absence of a pattern predicate if an expression predicate evaluates to false.

SelectOrSemiApply

Performs a nested loop. Tests for the presence of a pattern predicate if an expression predicate evaluates to false.

SemiApply

Performs a nested loop. Tests for the presence of a pattern predicate.

SetLabels

Sets labels on a node.

SetNodePropertiesFromMap

Sets properties from a map on a node.

SetProperty

Sets a property on a node or relationship.

SetRelationshipPropertiesFromMap

Sets properties from a map on a relationship.

ShortestPath

Finds one or all shortest paths between two previously matches node variables.

ShowConstraints

Lists the available constraints.

ShowFunctions

Lists the available functions.

ShowIndexes

Lists the available indexes.

ShowProcedures

Lists the available procedures.

ShowSettings

Lists the available configuration settings.

ShowTransactions

Lists the available transactions on the current server.

Skip

Skips n rows from the incoming rows.

Sort

Sorts rows by a provided key.

TerminateTransactions

Terminate transactions with the given IDs.

Top

Returns the first 'n' rows sorted by a provided key.

TriadicBuild

The TriadicBuild operator is used in conjunction with TriadicFilter to solve triangular queries.

TriadicFilter

The TriadicFilter operator is used in conjunction with TriadicBuild to solve triangular queries.

TriadicSelection

Solves triangular queries, such as the very common 'find my friend-of-friends that are not already my friend'.

UndirectedAllRelationshipsScan

Fetches all relationships and their start and end nodes in the database.

UndirectedRelationshipByIdSeek

Reads one or more relationships by ID from the relationship store.

UndirectedRelationshipIndexContainsScan

Examines all values stored in an index, searching for entries containing a specific string; for example, in queries including CONTAINS.

UndirectedRelationshipIndexEndsWithScan

Examines all values stored in an index, searching for entries ending in a specific string; for example, in queries containing ENDS WITH.

UndirectedRelationshipIndexScan

Examines all values stored in an index, returning all relationships and their start and end nodes with a particular relationship type and a specified property.

UndirectedRelationshipIndexSeek

Finds relationships and their start and end nodes using an index seek.

UndirectedRelationshipIndexSeekByRange

Finds relationships and their start and end nodes using an index seek where the value of the property matches a given prefix string.

UndirectedRelationshipTypeScan

Fetches all relationships and their start and end nodes with a specific type from the relationship type index.

UndirectedUnionRelationshipTypesScan

Fetches all relationships and their start and end nodes with at least one of the provided types from the relationship type index.

Union

Concatenates the results from the right-hand operator with the results from the left-hand operator.

UnionNodeByLabelsScan

Fetches all nodes that have at least one of the provided labels from the node label index.

Unwind

Returns one row per item in a list.

ValueHashJoin

Executes a hash join on arbitrary values.

VarLengthExpand(All)

Traverses variable-length relationships from a given node.

VarLengthExpand(Into)

Finds all variable-length relationships between two nodes.

VarLengthExpand(Pruning)

Traverses variable-length relationships from a given node and only returns unique end nodes.

VarLengthExpand(Pruning,BFS)

Traverses variable-length relationships from a given node and only returns unique end nodes.