Teradata Spool Space 101: Understanding, Managing, and Troubleshooting
Learn about Teradata Spool Space, a temporary workspace used to store intermediate and final result sets. Discover ways to increase and manage Spool Space.
spool space
How to get SQL Query Stats in Teradata
Learn how to determine SQL Query Performance in Teradata with these three essential parameters: AMPCPUTime, TotalIOCount, and SpoolUsage. Discover how to get SQL Query Stats and make the right decision for your queries using the DBC tables DBQLOGTBL and DBQLSQLTBL. Follow these three points to consider while running the query and get accurate results.