DWHPro Insights

ampcputime

How to get SQL Query Stats in Teradata Popular

Illustration of a stopwatch dial on an orange paint-splash background

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.