Hello there, it is an interesting discussion.

Thanks for the detailed explanations. It is helpful to know that KillExtent is faster but skips triggers, while DeleteExtent is more comprehensive, ensuring referential integrity and triggering deletes. Have you ever come across any specific scenarios; where one is clearly preferable over the other?