What is Spool Space in TeraData?
TERADATA Spool Space is unused Perm Space that it used for running queries. Spool Space is used to hold intermediate rows during processing, and to hold the rows in the answer set of a transaction.
TERADATA recommends 20% of the available perm space is allocated for Spool space but various across applications.
Insufficient spool error is usually the result of poor table design, poor data distribution, or a poorly written query. Running out of Spool Space will give the user an error code 2646.
Here are the contents that I wrote in this white paper:
1.Introduction………………………………………………………………………………….…3
1.1 Spool Space………………………………………………………………………….………3
1.2 Spool Space and Capacity Planning……………………………………………………..3
1.3 Spool Space Categories………………………………………………………………….4
1.4 Spool Space Allocation……………………………………………………………………4
-
Causes of spool space error and how to minimize it………………………………4
-
Know the data……………………………………………………………………………5
-
Primary Index…………………………………………………………………………….5
-
Multiset or Set table…………………………………………………………………… 6
-
Collect Statistics…………………………………………………………………………7
-
Skewing……………………………………………………………………………………7
-
Conclusion…………………………………………………………………………………8
-
References……………………………………………………………………………… 8
Here is the full contents in pdf format, Which can view as a presentation here: