I have a system wherein a few hundred queries that were run under one session that overall had over 15000 CPU seconds used. Could something be done to help reduce CPU usage. I am new to teradata so please help me with this.
Few things that come to mey mind:
Depending on the actual queries 15,000 CPU seconds for a few hundred queries might be low.
I've seen single Selects using a way more than 100,000 seconds.