skip to main content
Supported SQL Statements and Extensions for the Salesforce Driver : Set Checkpoint Defrag
  
Set Checkpoint Defrag
Purpose
Sets the threshold for triggering a Checkpoint Defrag. It is used in conjunction with the Checkpoint statement.
Syntax
SET CHECKPOINT DEFRAG size
where:
size
specifies the threshold size.
Notes
*When a Checkpoint statement is performed, either as a result of the .log file reaching the limit set by Set Logsize or by the user issuing a Checkpoint statement, the amount of abandoned space in the database data file(.data) is checked. If it is larger than the value of size, a CHECKPOINT DEFRAG, which eliminates the abandoned space, is performed instead of CHECKPOINT.
See also
Checkpoint