SYSCS_UTIL.SET_PURGE_DELETED_ROWS system procedure enables (or
disables) physical deletion of logically deleted rows from a specific
SYSCS_UTIL.SET_PURGE_DELETED_ROWS( VARCHAR schema, VARCHAR table, VARCHAR enable );
The name of the schema.
The name of the table
A Boolean specifying whether or not to physically delete rows that have been logically deleted during major compaction.
This procedure does not return a result.
If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.
This specifies that deleted rows from
my_table will be physically
deleted when the next major compaction is run:
CALL SYSCS_UTIL.SET_PURGE_DELETED_ROWS('SPLICE', 'my_table', true);