G select a from a group by a; (after rewrites) cluster3 Box3:Select cluster1 Box1:BaseTable A boxhead3 Distinct: Enforce 0: Q0.c0 as A UNIQUE KEY [0] Q0 Q0(F) as A boxhead1 Distinct: Preserve 0: c0 as A Q0->boxhead1