Derby is 18.8. From the Derby 10.8 reference manual, I fiind: SELECT T2.* FROM SYS.SYSTABLES systabs, TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2 WHERE systabs.tabletype = 'T' AND systabs.tableid = T2.tableid;
If I try to run that, I get: Error: No constructor was found with the signature org.apache.derby.diag.SpaceTable(). It may be that the parameter types are not method invocation convertible. SQLState: 42X75 ErrorCode: -1 Any ideas on how to run that to get the space used by each table/index?