database - Get the space used by a table in Apache Derby -


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