Db2建表使用多个分布键时，如何查看数据分布？
Db2建表后，如果是单个分布键是有一个函数可以通过select order by 查看数据分布的，但使用2个以上的分布键的时候应该如何查看数据分布呢？
1同行回答
假设两个字段名为a，b，表名为t, 先手工对a，b进行分段定义，然后写sql语句进行分段统计：
select case when a between 1 and 100 then 'a_1_100'
when a between 101 and 200 then 'a_101_200'
end a_value,
case when b between 1 and 100 then 'b_1_100'
when b between 101 and 200 then 'b_101_200'
end b_value, count(*)
from t
group by
case when a between 1 and 100 then 'a_1_100'
when a between 101 and 200 then 'a_101_200'
end ,
case when b between 1 and 100 then 'b_1_100'
when b between 101 and 200 then 'b_101_200'
end
order by 1,2;