1 Reply Latest reply on Oct 8, 2002 3:27 AM by Alexey Loubyansky

    Single statement deletion of cascade-delete child entity row

    John Sissler Newbie

      Given a tree of related entities, is there a fundamental reason (complexity?) why the CMP engine could not be optimized to perform single statement deletion of child entity rows bottom up?

      e2 -> e1 -> e0

      delete e2 where e2.e1.e0 = e0
      delete e1 where e1.e0 = e0
      delete e0

      rather than

      foreach e1 in e0
      __foreach e2 in e1
      ____delete e2
      __delete e1
      delete e0