Creating a Nonlogging Temporary Table

When you create a temporary table with the SELECT...INTO TEMP statement, the temporary table is a logging table by default. If you do not care to log transactions in this temporary table, specify the WITH NO LOG clause on the SELECT...INTO TEMP statement or create a scratch table.

The database server uses the dbspaces specified in the DBSPACETEMP configuration parameter or DBSPACETEMP environment variable when you specify either of the following items:

• SELECT...INTO TEMP <temp_table> WITH NO LOG
• SELECT...INTO SCRATCH <temp_table>

If you use the default value of NONCRITICAL for DBSPACETEMP, the optimizer stores temporary tables in any dbspace that does not contain critical files such as logical logs.

For more information on improving performance with temporary tables, see your IBM Informix: Performance Guide and Temporary Tables.