DEFRAG TABLE IMAGE

The DEFRAG TABLE IMAGE command allows the historic rows held in RAM for a table to be discarded, freeing up memory; previously the only way to achieve this was to drop and recreate the table image.

Usage

DEFRAG TABLE IMAGE table [FORCE]

Notes

By default the command will only perform the de-fragmentation if more than 10% of the rows will be discarded from the image; however the FORCE option ensures the de-fragmentation is performed regardless of how much RAM will be freed.