db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: a command to show table file-size?
Date Sun, 10 Jun 2007 13:17:26 GMT
Geoff hendrey <geoff_hendrey@yahoo.com> writes:

> Is there a utility or command that I can use to
> identify the disk space (bytes) occupied by a
> particular table?

This query will give you information about the number of pages and the
size of the pages in the table T in schema APP:

select * from new org.apache.derby.diag.SpaceTable('APP', 'T') as space_table;

-- 
Knut Anders

Mime
View raw message