COMPACT

When a user executes the SQL command DELETE, data is logically deleted. The COMPACT command permanently removes deleted lines from Indexima structures.

Syntax

ALTER TABLE <table> COMPACT

SQL

<table>

The table you want to compact.

Output

This SQL command does not return anything.

This operation can trigger a COMMIT if required before.