It seems that "GROUP BY PLACEMENT" trasformation was performed before transitive closure, so transitive closure was not performed after this trasformation. -- Best regards, Sayan Malakshinov Senior performance tuning engineer PSBank http://orasql.org