IBM® Informix® 12.10
Explicit inserts with SELECT...INTO TEMP statements
The database server can insert rows in parallel into explicit temporary tables that you specify in SQL statements of the form SELECT....INTO TEMP.
For example, the database server can perform the inserts
in parallel into the temporary table, temp_table, as the following
example shows:
SELECT * FROM table1 INTO TEMP temp_table
To perform parallel inserts into a temporary table:
The database server performs the parallel insert by writing in parallel to each of the fragments in a round-robin fashion. Performance improves as you increase the number of fragments.