Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.