IterativeDelete - What does it really do?

[GeoffreyOptumOp]

I see the "IterativeDelete" property documented here:  Dictionary Attributes

But I still don't understand it.  Can someone please explain, in more detail, what this does behind the scenes?  Does it translate to SQL (what exactly) under the covers?

Does "iteratively" mean "one at a time"?  As opposed to (somehow) all at once (simultaneously)?

If so, why would I ever want to delete "iteratively"?  How is that going to help me?

Thanks.

[GeoffreyOptumOp · Accepted solution]

Based on this article it sounds like Iterative Delete means the following:

Iterative Delete

- Deletions will be performed via the GlideRecord object.

- Business Rules and Workflows WILL be triggered by any record deletion (may be slow)

- Deletion WILL be audited and/or tracked by update sets (for tables participating in Update Sets).