select t.tabschema,t.tabname,decimal(float(t.npages)*float(ts.pagesize)/(1024.0*1024.0),10,2) as tab_size_mb from syscat.tables t &nbs...
显示全部select t.tabschema,t.tabname,decimal(float(t.npages)*float(ts.pagesize)/(1024.0*1024.0),10,2) as tab_size_mb
from syscat.tables t
join syscat.tablespaces ts
on t.tbspaceid=ts.tbspaceid
where t.tabschema='AB_IBAS'
AND t.TBSPACE = 'TBS_BAS_AB'
AND t.OWNER = 'AB_IBAS'
order by tab_size_mb desc
收起