ASA Database Administration Guide
Database Options
Alphabetical list of options
To speed up TRUNCATE TABLE statements
ON, OFF
Can be set only for the PUBLIC group.
ON
If TRUNCATE_WITH_AUTO_COMMIT is set to ON, then a COMMIT is executed both before and after the TRUNCATE TABLE statement is executed. The primary purpose of the option is to enable faster table truncation (delete of all rows).
There are some cases where a fast TRUNCATE cannot be done:
If there are foreign keys either to or from the table
If the TRUNCATE TABLE statement is executed within a trigger
If the TRUNCATE TABLE statement is executed within an atomic statement