Loading Modes

The database server performs express-mode loads and deluxe-mode loads. Mode selection is determined by the logging mode (table type) of the destination table and the presence or absence of the DELUXE or EXPRESS keywords in the USING clause of the CREATE EXTERNAL TABLE statement. You can perform express-mode loads only when the table is type RAW or OPERATIONAL and does not have any active indexes. The database server allows constraint checking for both load modes.

Express mode provides the highest performance during a load. For detailed procedures on using express mode, refer to Loading Data in Express Mode.

Deluxe mode combines fast parallel loading with evaluation of indexes and unique constraints. Use deluxe mode in the following situations:

• The cost of rebuilding an index is too high for the amount of data that you are loading.
• You want to use the empty space from deleted rows in the table that you are loading.

For detailed procedures on using deluxe mode, refer to Loading Data in Deluxe Mode.