Compact Tables are used to free memory for tables that contain deleted rows.
When a user executes the SQL commands DELETE, data is deleted. The COMPACT command permanently removes deleted lines from Indexima structures.
ALTER TABLE my table COMPACT
This operation can trigger a COMMIT if required before.
Note: When a table contains more than 40% of deleted lines the notification panel will display a warning for this table.
In order to compact, data is temporarily duplicated.
The old data (=buckets) is deleted ~1min after the end of the compaction.