Cypher optimitization

[idrismunir]

Hi Michael,
I need your help in optimising this cypher query to run pretty much faster preferably in milliseconds.

match (c:client{client_id:$var3}) optional match (d:client) where (c.address =d.address or c.employer =d.employer) and c<>d and d.status ='WRITE_OFF' return count(distinct d)

Thanks so much.

[michael_hunger · Accepted solution]

Please share the expanded query plan with PROFILE

Make sure to have an index on employer and addres
Perhaps a union would work better than the OR

How many status do you have?

[idrismunir]

Hi Michael,
Thanks for your help. Having indexes on both employer and address solved the problem.