All asset manager delete queries suffer from very poor performance in
large systems since they always probing for orphaned properties of any
media packages and will always create a joined table of all snapshots
and all properties in the process, even if it is completely unnecessary
like in the case of updating the ACL properties.