How can I best determine how much temp space a Global Temporary Table used during SQL execution? We're running Teradata 14.10 in DEV & QA, and 13.10 in Prod, if it matters.
afaik there's no info about temp space usage in DBQL.
But you can get the combined size of all GTTs within a session using
SELECT VProc, CurrentTemp
WHERE databasename = 'username';
So simply run this after populating the GTT(s)
Thanks very much...just what I needed. I'm still learning where all of this information is stored, so I really appreciate your response.