Advantages of nonlogging tables

Nonlogging tables, which are also called raw tables, have characteristics that enable you to load very large data warehousing tables quickly.

Raw tables have following characteristics:
  • They do not use CPU and I/O resources for logging.
  • They avoid problems such as running out of logical-log space.
  • They are locked exclusively during an express load so that no other user can access the table during the load.
  • They do not support referential constraints and unique constraints, so overhead for constraint-checking is eliminated.

Copyright© 2018 HCL Technologies Limited