db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Question for "in place" of SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure
Date Thu, 22 Mar 2007 14:34:17 GMT
> The wording what I could not translate was "in place".

I understand this to mean: "in the same file".

That is, the in-place compress avoids copying the table to
a new file. Since this version of the compress tool does not
make a new file, the underlying file remains the same size
in bytes, and the disk space usage as measured by the operating
system is not reduced by the compress.

It just re-arranges the space within the pages of the file.

thanks,

bryan


Mime
View raw message