Maximum space in bytes allowed for spool files for the specified user.
- Integer, decimal, or floating point value.
- A constant expression is any SQL expression that does not make any column references. Specifying an appropriate constant expression for the SPOOL space size of a user 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 space size based on a constant expression, the assigned size does not automatically scale if, for example, you add more AMPs to your system.
- Optional keyword that redundantly specifies the unit for the amount of space allowed.