What is spool space and when running
a job if it reached the maximum spool space how you solve the problem in
Teradata?
Spool space is the space which is required by the
query for processing or to hold the rows in the answer set. Spool space reaches
maximum when the query is not properly optimized. We must use appropriate
condition in WHERE clause and JOIN on correct columns to optimize the query.
Also make sure unncessary volatile tables are dropped as it occupies spool
space.
No comments:
Post a Comment