Using the WITH NO LOG Option

Use the WITH NO LOG option to reduce the overhead of transaction logging because operations on nonlogging temporary tables are not logged.

A nonlogging temporary table exists until one of the following events occurs:

• The application disconnects.
• A DROP TABLE statement is issued on the temporary table.

Because nonlogging temporary tables do not disappear when the database is closed, you can use a nonlogging temporary table to transfer data from one database to another while the application remains connected. The behavior of a temporary table that you create with the WITH NO LOG option of the INTO TEMP clause is the same as that of a scratch table.

For more information about temporary tables, see CREATE Temporary TABLE .