match (n:USER
) where id(n) in [多个id]
MATCH (n)<-[r3:CBK_ENGINEER]-(y:USER
)
WHERE r3.first_cbkmark_on < 20220401 and id(n)<>‘244309430’
WITH count(distinct case when y is not null then n else null end) as n_cbkin_Engineer_2nd_v4
return n_cbkin_Engineer_2nd_v4
User点有16亿 查询的时候,这个cypher耗时非常长,请问这个如何优化呢