| explain plan for select * from ( select sum(col_int), count(distinct col_bgint), col_boln from (select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v`) tmp group by tmp.col_boln ) t limit 0; |