Sizing Needs | Database Design | Teradata VantageCloud Lake - Sizing Spool Space - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

The database uses spool space as temporary storage for result rows that are returned for user requests. Spool space, though temporary, is frequently overlooked in capacity planning, but 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. Large systems use more spool than smaller systems. Spool rows have a maximum length of approximately 1MB.