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.

INFO

This operation can trigger a COMMIT if required before.