select t.tabname,'Normal' as tabtype,p.nrows as nrows,
p.nptotal, (p.npused/decode(p.nptotal,0,1,p.nptotal)*100)::decimal(5,2) as usedperc
from systables t, sysmaster:sysptnhdr p
where t.partnum = p.partnum
and t.tabid > 99
and t.tabtype = 'T'
union
select t.tabname,'Fragment' as tabtype, sum(p.nrows) as nrows,
sum(p.nptotal) as nptotal, (sum(p.npused)/sum(decode(p.nptotal,0,1,p.nptotal))*100)::decimal(5,2) as usedperc
from systables t, sysfragments f, sysmaster:sysptnhdr p
where t.tabid = f.tabid
and t.tabid > 99
and f.partn = p.partnum
and f.fragtype = 'T'
group by 1;
gbase8s查询业务表的行数--普通表加上分片表
于 2024-03-22 17:54:06 首次发布