Storage Options

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > CREATE Temporary TABLE >

Storage Options

Use the storage-option segment of the CREATE Temporary Table statement to specify the storage location and distribution scheme for the table. This is an extension to the ANSI/ISO standard for SQL syntax. Unlike the corresponding storage-options segment of the CREATE TABLE statement, no EXTENT SIZE options are supported for temporary tables.

Storage Options:
 
|--+-----------------------------+------------------------------>
   +-IN--+-dbspace---------+-----+
   |     |  (1)            |     |
   |     +--------dbslice--+     |
   |     |  (2)            |     |
   |     '--------extspace-'     |
   |                        (3)  |
   '-| FRAGMENT BY Clause |------'
 
>--+----------------------------+-------------------------------|
   |  (2)                  (4)  |
   '--------| PUT Clause |------'

Notes:

Extended Parallel Server only
Dynamic Server only
See page FRAGMENT BY Clause
See page PUT Clause (IDS)

Element	Description	Restrictions	Syntax
dbspace	Dbspace in which to store the table.	Must already exist	Identifier, p. Identifier
dbslice	Name of the dbslice in which to store the table	Must already exist	Identifier, p. Identifier
extspace	Name that onspaces assigned to a storage area outside the database server	Must already exist	See documentation for access method.

To create a fragmented, unique index on a temporary table, you must specify an explicit expression-based distribution scheme for a temporary table in the CREATE Temporary TABLE statement.

If you are using Extended Parallel Server, you can fragment a temporary table across multiple dbspaces that different coservers manage.