Temporary-Table Fragmentation

Users or client applications can use the following SQL statements to create temporary tables:

• CREATE TEMP TABLE or CREATE SCRATCH TABLE
• SELECT INTO TEMP or SELECT INTO SCRATCH

Depending on the expected size of a temporary table and its later use, you might decide to fragment the table explicitly or allow the database server to determine how the fragments of the table are distributed. For information about how the database server stores temporary table fragments by default, see the CREATE Temporary TABLE section in the IBM Informix: Guide to SQL Syntax.

For information about performance aspects of temporary tables, see Using Temporary Tables. To display information about the number of temporary space pages in use and available, execute onstat -g tmp.