Uncategorized

White paper on Spool Space in Teradata

White paper on Spool Space in TeraData was presented by Me at Wipro where I work on Teradata presently. So first questions arises:

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.

In the majority of cases, well written SQL queries should not use huge amounts of spool space. A poor choice of join column, product join and lack of statistics are the main reason of excessive spool space consumption. Each user can be set a spool space limit. In later version of TERADATA, this is often set in the user’s profile.
 
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

  1.   Causes of spool space error and how to minimize it………………………………4

  1.   Know the data……………………………………………………………………………5

  1.   Primary Index…………………………………………………………………………….5

  1.   Multiset or Set table……………………………………………………………………  6

  1.   Collect Statistics…………………………………………………………………………7

  1.   Skewing……………………………………………………………………………………7

  1.   Conclusion…………………………………………………………………………………8

  1.   References………………………………………………………………………………  8

Here is the full contents in pdf format, Which can view as a presentation here:
 

White paper on Spool space in teradata

View more documents from Alien Coders

Comments are closed.