Contents Index TRUNCATE_TIMESTAMP_VALUES option [database] TRUNCATION_LENGTH option [ISQL]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

TRUNCATE_WITH_AUTO_COMMIT option [database]


Function 

To speed up TRUNCATE TABLE statements

Allowed values 

ON, OFF

Scope  

Can be set only for the PUBLIC group.

Default 

ON

See also 

TRUNCATE TABLE statement

Description 

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:


Contents Index TRUNCATE_TIMESTAMP_VALUES option [database] TRUNCATION_LENGTH option [ISQL]