DETACH DELETE vs DROP

General Graph Academy
1

https://graphacademy.neo4j.com/courses/importing-cypher/4-import-considerations/1-build-import-process/

"Before you can re-run the import process, you must delete any existing data and drop any constraints."

DELETE is only possible for unconnected Nodes, DETACH DELETE can delete both at the same time.
-> Is it not faster to Drop the whole db and recreate it? If you only have lookup-Indexes...

2

I use “create or replace ” all the time in test databases, but it is only available in the enterprise edition; therefore, you will need to use “detach delete” (which can be slow).

1 Like