Chapter 3: Minimally Logged DML

To optimize the log records that are flushed to the transaction log on disk, Adaptive Server can perform minimal to no logging when executing some data manipulation language (DML) commands—insert, update, delete, and slow bcp—on all types of low-durability databases, such as in-memory databases and low-durability databases that use the at_shutdown and no_recovery options. You can perform minimal logging for DMLs on a per-database, per-table, and session-specific basis.