Understand and Avoid the No More Spool Space Issue in Teradata

Posted on Jun 22, 2020 in Computer Science

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement! **

Knowledge About Spool Space in Teradata

  1. Volatile Tables and subqueries are both built in Spool

Causes of No More Spool Issue

  1. The main cause of "no more spool space" errors is usually data skew.

Some Potential Solutions

  1. Choose a good primary index when creating a data tabel.

  2. Reduce the number of rows and columns you’re working with

  3. Break down a big query into smaller ones.

  4. Use Subqueries to Reduce Joined Rows and Columns

  5. reduce spool with COMPRESS

References

https://robertlambert.net/2018/02/escaping-teradata-purgatory-select-failed-2646-no-more-spool-space/

Computer Science Teradata spool space no more spool space database SQL