When a user executes the SQL command DELETE, data is logically deleted. The COMPACT command permanently removes deleted lines from Indexima structures.
ALTER TABLE <table> COMPACT
The table you want to compact.
This SQL command does not return anything.
This operation can trigger a COMMIT if required before.