I have graph where location is root node under which I have cloud resources. These location connect with other through a pair of gateways connected by bi directional HAS_REMOTECONNECTION edge.
How can I optimize following query where I am trying to delete everything under a location including location itself?
<code>MATCH (loc:location{resource_id:<resource_id>, tenant_id:<tenant_id>})-[:LOCATION_HAS_DE]->(deplenvs:(cluster|node|vpc))
MATCH (deplenvs)-[:DE_HAS_GW]->(gateways)
MATCH (deplenvs)-[:DE_HAS_PART]->(parts)-[*]->(extras)
RETURN loc, deplenvs, gateways, parts, extras
</code>
<code>MATCH (loc:location{resource_id:<resource_id>, tenant_id:<tenant_id>})-[:LOCATION_HAS_DE]->(deplenvs:(cluster|node|vpc))
MATCH (deplenvs)-[:DE_HAS_GW]->(gateways)
MATCH (deplenvs)-[:DE_HAS_PART]->(parts)-[*]->(extras)
RETURN loc, deplenvs, gateways, parts, extras
</code>
MATCH (loc:location{resource_id:<resource_id>, tenant_id:<tenant_id>})-[:LOCATION_HAS_DE]->(deplenvs:(cluster|node|vpc))
MATCH (deplenvs)-[:DE_HAS_GW]->(gateways)
MATCH (deplenvs)-[:DE_HAS_PART]->(parts)-[*]->(extras)
RETURN loc, deplenvs, gateways, parts, extras