您可以使用COUNT子查询（从Neo4j 5.3开始可用）来内联SET子句的邻居计数。
此示例等效于初始查询，减去返回原始图：

MATCH (n)-[r]->(c:!_event)
WITH collect(DISTINCT n) + collect(DISTINCT c) AS ncs, collect(r) AS rs
UNWIND ncs AS nc
SET nc.counter = COUNT { (nc)-[r WHERE r IN rs]-() }

COUNT子查询表示数据库命中。作为替代方案，您可以通过仅计算第一个MATCH中的关系来避免后续的DB命中：

MATCH (n:A)-->(c:!_event)
WITH collect(n) + collect(c) AS ncs
UNWIND ncs AS nc
WITH nc, count(*) AS counter
SET nc.counter = counter

下面的查询只需要一个MATCH，不需要APOC。CALL subqueries不返回任何内容，因此保留单个外部行。

.
.
.
MATCH (n)-[rel]->(:!_event) //n was defined earlier, and here we exclude _events
WITH COLLECT(rel) as rels
CALL {
  WITH rels
  UNWIND rels AS r
  WITH STARTNODE(r) AS n, COUNT(*) AS countC
  SET n.counter = countC
}
CALL {
  WITH rels
  UNWIND rels AS r
  WITH ENDNODE(r) AS c, COUNT(*) AS countN
  SET c.counter = countN
}
UNWIND rels AS r
RETURN STARTNODE(r) AS n, r, ENDNODE(r) AS c