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