Transaction Logging During Bulk and Incremental Copy
The bulk copy requires only minimal transaction logging.
Note: A transaction is still entered into the log file and normal logging occurs for the associated system catalogs.
In contrast, an incremental copy can generate a large number of transaction log records. The incremental copy requires logging for every record transfer and every structural change to the table.
An alternative method to reducing logging is described in
Large Data Loads with the SET NOLOGGING Statement.
Last modified date: 11/28/2023