is possible how space used table in apache derby?
the following statement returns size each table:
select tablename, (select sum(numallocatedpages * pagesize) new org.apache.derby.diag.spacetable('app', t.tablename) x) size sys.systables t order size desc
Comments
Post a Comment