The query construction for a retention policy is optimized. Child tables have a metadata column, either a tag or legal-hold column, that gets populated with the attribute applied to the parent. This allows the query to construct a join of just the child and immediate parent.
Previously, the query constructed a join that included the child, immediate parent, grandparent, and beyond. This strategy did not successfully scale to more than seven to eight levels.