Advantages of logging tables
Logging type options specify the logging characteristics that can improve performance in various bulk operations on the table.
STANDARD, which corresponds to a table in a logged database of previous versions, is the default logging type that is used when you issue the CREATE TABLE statement without specifying the table type.
Standard tables have the following features:
- Logging to allow rollback, recovery, and restoration from archives.
- Recovery from backups
- All insert, delete, and update operations
- Constraints to maintain the integrity of your data
- Indexes to quickly retrieve a small number of rows
OLTP applications usually use standard tables. OLTP applications
typically have the following characteristics:
- Real-time insert, update, and delete transactions
Logging and recovery of these transactions is critical to preserve the data. Locking is critical to allow concurrent access and to ensure the consistency of the data selected.
- Update, insert, or delete one row or a few rows at a time
Indexes speed access to these rows. An index requires only a few I/O operations to access the pertinent row, but scanning a table to find the pertinent row might require many I/O operations.