Compact Tables

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.

SQL

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 detail

In order to compact, data is temporarily duplicated.

The old data (=buckets) is deleted ~1min after the end of the compaction.