Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Table performance considerationsSome performance issues are associated with unfragmented tables and table fragments.
Changing tables to improve performanceYou can change tables to improve performance by dropping indexes, attaching or detaching fragments, and altering table definitions. You can also create databases for decision-support applications by unloading and loading tables in OLTP databases.
Loading and unloading tablesYou can create databases for decision-support applications by periodically loading tables that have been unloaded from active OLTP databases.
Advantages of nonlogging tablesNonlogging tables, which are also called raw tables, have characteristics that enable you to load very large data warehousing tables quickly.

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.

About this task

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.