Segmentation Fault Kore Dumped

If rows are deleted from the Apache Derby Database, the table doesn't get compressed automagically. You need to execute the following command with derby utility "ij".

call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('SCHEMA-NAME', 'TABLE-NAME', 1)

The third option is something called "sequential" which takes less memory and space, as you have guessed it, more time. But, really it is not that slow. It reduced the 1.3 G table to 600M in less than a minute. More gyaan on the man page.

Labels: cleanup, compress, derby