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.