G select * from a where a >= ANY(select c from c); (before rewrites) cluster0 Box0:Select cluster2 Box2:Select cluster3 Box3:BaseTable C cluster1 Box1:BaseTable A boxhead0 Distinct: Preserve 0: Q0.c0 as A 1: Q0.c1 as B Q0 Q0(F) as A Q2 Q2(Any) Q0->Q2 (Q0.c0) >= (Q2.c0) boxhead1 Distinct: Preserve 0: c0 as A 1: c1 as B Q0->boxhead1 boxhead2 Distinct: Preserve 0: Q1.c0 as C Q2->boxhead2 Q1 Q1(F) as C boxhead3 Distinct: Preserve 0: c0 as C 1: c1 as D Q1->boxhead3