Extended Parallel Server supports the INTO Scratch clause. This can improve performance, because scratch tables are not logged. A scratch table does not support indexes or constraints. It persists until the application disconnects, or a DROP TABLE statement is issued on the temporary table.
Because scratch tables do not disappear when the database is closed, you can use a scratch table to transfer data from one database to another while the application remains connected. A scratch table is identical to a temporary table that is created with the WITH NO LOG option. For more information about scratch tables, see CREATE Temporary TABLE .
Place the UNION operator between two SELECT statements to combine the queries into a single query. You can string several SELECT statements together using the UNION operator. Corresponding items do not need to have the same name. Omitting the ALL keyword excludes duplicate rows.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]