We have a few AO tables (which nowadays means "Append Optimized", not "Append Only"). Normally, we just insert into these tables.
As part of a significant system change, I need to do a fairly large delete from these tables. It's only about 2% of the data volume, and only over a small range of partitions. Eventually those partitions will roll off the end of our retention policy.
I can't find any information on the consequences of executing a delete on an AO table.