The number of bytes to allocate for global temporary table space.
If no temporary space is defined in the profile assigned to a user, Vantage uses the setting defined for the individual user. Temporary space is reserved prior to spool space for any user defined with this characteristic. Disk usage for a materialized global temporary table is charged to the temporary space allocation of the user who referenced the table.
The default is NULL, which uses the setting defined for the individual user. Changes to the temporary space allocation in a profile take effect immediately upon submitting the MODIFY PROFILE request.
- n
- n can be an integer, a decimal value, or a floating point value.
- constant_expression
- Any SQL expression that does not make any column references. Specifying an appropriate constant expression for the TEMPORARY space size of a user enables Vantage to assign an optimal quantity of TEMPORARY space that scales to the size of your system by allocating TEMPORARY space on a per AMP basis.
- BYTES
- Optional keyword.