Differences between base table, auxiliary table and temporary table

Base Table

1. A base table is a table created with the SQL statement CREATE TABLE.
2. Used to hold persistent user data

Auxiliary Table

1. An auxiliary table is a table created with the SQL statement CREATE AUXILIARY TABLE.
2. Used to hold the data for a column that is defined in a base table.

Temporary Table

1. A temporary table is a table described by the SQL statement CREATE GLOBAL TEMPORARY TABLE.
2. Used to hold data temporarily, such as the intermediate results of SQL transactions.
3. Temporary tables persist as long as the application supports them.
4. Table space and database operations, locking, logging, and recovery do not apply.