G select distinct a.* from a as a(a,b), b as b(b,c), c as c(c, d) cross join (d as d(d, e) cross join (f as f(f, h) cross join lateral(select a.a, b.b, c.c, d.d, e.e, f.f from e as e(e, f)))) cluster0 Box0:Select cluster5 Box5:Select cluster8 Box8:Select cluster9 Box9:Select cluster12 Box12:Select cluster13 Box13:Select cluster16 Box16:Select cluster18 Box18:Select cluster17 Box17:BaseTable cluster15 Box15:Select cluster14 Box14:BaseTable cluster11 Box11:Select cluster10 Box10:BaseTable cluster7 Box7:Select cluster6 Box6:BaseTable cluster4 Box4:Select cluster3 Box3:BaseTable cluster2 Box2:Select cluster1 Box1:BaseTable boxhead0 Distinct: Enforce 0: Q1.C0 as a 1: Q1.C1 as b Q1 Q1(F) as a boxhead2 Distinct: Preserve 0: Q0.C0 as a 1: Q0.C1 as b Q1->boxhead2 Q3 Q3(F) as b boxhead4 Distinct: Preserve 0: Q2.C0 as b 1: Q2.C1 as c Q3->boxhead4 Q17 Q17(F) Q17->Q1 correlation Q17->Q3 correlation boxhead5 Distinct: Preserve 0: Q5.C0 as c 1: Q5.C1 as d 2: Q16.C0 as d 3: Q16.C1 as e 4: Q16.C2 as f 5: Q16.C3 as h 6: Q16.C4 as a 7: Q16.C5 as b 8: Q16.C6 as c 9: Q16.C7 as d 10: Q16.C8 as e 11: Q16.C9 as f Q17->boxhead5 Q5 Q5(F) as c boxhead7 Distinct: Preserve 0: Q4.C0 as c 1: Q4.C1 as d Q5->boxhead7 Q16 Q16(F) Q16->Q5 correlation boxhead8 Distinct: Preserve 0: Q15.C0 as d 1: Q15.C1 as e 2: Q15.C2 as f 3: Q15.C3 as h 4: Q15.C4 as a 5: Q15.C5 as b 6: Q15.C6 as c 7: Q15.C7 as d 8: Q15.C8 as e 9: Q15.C9 as f Q16->boxhead8 Q15 Q15(F) boxhead9 Distinct: Preserve 0: Q7.C0 as d 1: Q7.C1 as e 2: Q14.C0 as f 3: Q14.C1 as h 4: Q14.C2 as a 5: Q14.C3 as b 6: Q14.C4 as c 7: Q14.C5 as d 8: Q14.C6 as e 9: Q14.C7 as f Q15->boxhead9 Q7 Q7(F) as d boxhead11 Distinct: Preserve 0: Q6.C0 as d 1: Q6.C1 as e Q7->boxhead11 Q14 Q14(F) Q14->Q7 correlation boxhead12 Distinct: Preserve 0: Q13.C0 as f 1: Q13.C1 as h 2: Q13.C2 as a 3: Q13.C3 as b 4: Q13.C4 as c 5: Q13.C5 as d 6: Q13.C6 as e 7: Q13.C7 as f Q14->boxhead12 Q13 Q13(F) boxhead13 Distinct: Preserve 0: Q9.C0 as f 1: Q9.C1 as h 2: Q12.C0 as a 3: Q12.C1 as b 4: Q12.C2 as c 5: Q12.C3 as d 6: Q12.C4 as e 7: Q12.C5 as f Q13->boxhead13 Q9 Q9(F) as f boxhead15 Distinct: Preserve 0: Q8.C0 as f 1: Q8.C1 as h Q9->boxhead15 Q12 Q12(F) Q12->Q9 correlation boxhead16 Distinct: Preserve 0: Q1.C0 as a 1: Q3.C0 as b 2: Q5.C0 as c 3: Q7.C0 as d 4: Q11.C0 as e 5: Q9.C0 as f Q12->boxhead16 Q11 Q11(F) as e boxhead18 Distinct: Preserve 0: Q10.C0 as e 1: Q10.C1 as f Q11->boxhead18 Q10 Q10(F) boxhead17 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q10->boxhead17 Q8 Q8(F) boxhead14 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q8->boxhead14 Q6 Q6(F) boxhead10 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q6->boxhead10 Q4 Q4(F) boxhead6 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q4->boxhead6 Q2 Q2(F) boxhead3 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q2->boxhead3 Q0 Q0(F) boxhead1 Distinct: Preserve 0: C0 as column1 1: C1 as column2 2: C2 as column3 Q0->boxhead1