This section describes the different table types that can be particularly useful in data-warehousing environments. Extended Parallel Server logs tables by default, the same way that Dynamic Server logs tables. However, data-warehousing environments and other applications that involve large amounts of data (and few or no inserts, updates, or deletes) often require a combination of logged and nonlogged tables in the same database. In many cases, temporary tables are insufficient because they do not persist after the database session ends. To meet the need for both logging and nonlogging tables, Extended Parallel Server supports the following types of permanent tables and temporary tables:
If you issue the CREATE TABLE statement and you do not specify the table type, you create a standard permanent table. To change between table types, use the ALTER TABLE statement. For information about the syntax, refer to the IBM Informix: Guide to SQL Syntax.