Re: a command to show table file-size?

[Knut Anders Hatlen]

Geoff hendrey <[EMAIL PROTECTED]> 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