15.10 - SPOOL - Teradata Database

Number of bytes to be allowed for spool and volatile temporary tables in database_name. The default is the largest value that is not greater than the immediate owner spool space and that is a multiple of the number of AMPs on the system.

n

You can enter the number of bytes as an integer, decimal, or floating point value or as a constant expression whose evaluation determines the number of bytes. You can also enter the value using exponential notation. For example, you can write one thousand as either 1000 or 1E3.

n cannot exceed the spool space parameter in the profile of the creator. If no spool space is defined for that profile, then Teradata Database uses the spool space limit defined for the individual user-creator.

BYTES

Optional keyword that redundantly specifies the unit for the amount of space allowed.

constant_expression BYTES

A constant expression is any SQL expression that does not make any column references. Specifying an appropriate constant expression for the SPOOL size of a database enables Teradata Database to assign an optimal quantity of SPOOL that scales to the size of your system by allocating SPOOL space on a per AMP basis.

When you specify a SPOOL size based on a constant expression, the assigned size does not automatically scale if, for example, you add more AMPs to your system.