This mostly applies to almost any database. Deletes are Writes and Writes are resource intensive. This is more prominent on databases like Elastic Search. Whe

This mostly applies to almost any database. Deletes are Writes and Writes are resource intensive. This is more prominent on databases like Elastic Search. When I was tasked to delete millions of (old) documents, it overloaded the cluster and almost brought it down. Only scalable solution was to split the index and drop the whole index.