I have no idea if this applies, but one problem with using this method
is that the space table will report space that is allocated to deleted
rows. reclamation of deleted rows is deferred so if you have deleted
rows, or aborted inserts, or attempted to insert rows but failed due
to duplicate key
org
Subject: table size estimation
This is a follow up email to my earlier posting regarding storage. Based on the
query given,
select * from NEW org.apache.derby.diag.SpaceTable('SYS','SYSTABLES') AS x;
using it for my table, the estimated size of a record is coming to be 131
This is a follow up email to my earlier posting regarding storage. Based on the query given,select * from NEW org.apache.derby.diag.SpaceTable('SYS','SYSTABLES') AS x;using it for my table, the estimated size of a record is coming to be 131 bytes. The table consists of 5 bigints, 3 smallints, 1 tim