Logging Options
Use the Logging Type options to specify logging characteristics that can improve performance in various bulk operations on the table.
Other than the default option (STANDARD) that is used for OLTP databases, these logging options are used primarily to improve performance in data warehousing databases.
A permanent table can have either of the following logging characteristics.
- Logging Type
- Effect
- STANDARD
- Logging tables that allow rollback, recovery, and restoration from archives. This type is the default. Use this type of table for all the recovery and constraints functionality that OLTP databases require.
- RAW
- Nonlogging tables that do not support primary key constraints or unique constraints. but that support referential constraints, and can be indexed and updated. Use this type of table for quickly loading data.
The CREATE RAW TABLE statement is not supported on secondary servers within a high-availability cluster.
For more information on these logging types of tables, refer to your HCL OneDB™ Administrator's Guide.