Home | Previous Page | Next Page   Dimensional Databases > Implementing a Dimensional Database (XPS) >

Logging and Nonlogging Tables in Extended Parallel Server

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.

Important:
A coserver can use and access only its own dbspaces for temporary space. Although temporary tables can be fragmented explicitly across dbspaces like permanent tables, a coserver inserts data only into the fragments that it manages.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]