Sizing Spool Space - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Sizing Spool Space

Teradata Database uses spool space as temporary storage for result rows that are returned for user requests. Because spool space is a form of temporary space, it is frequently overlooked in capacity planning, yet it is critical to the operations of the database. Spool space needs vary from table to table, user to user, application to application, and with frequency of use. Very large systems use even more spool than smaller systems. Unlike all other row types, spool rows have a maximum length of approximately 1MB rather than 64KB.

Spool falls into these categories:

  • Intermediate
  • Output
  • Persistent
  • Volatile