DBQL Metrics

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.

DBQL Metrics

I want to capture execution time,ampcpu time from dbc log tables for 20 specific queries between 2 days
So that i can check the execution time and cpu consumed on two different dates.
Could some one please help me writing a script when i pass batch id and different dates, it should
display
UserName,StatementType,Time_Taken_day1,Time_Taken_day2,AMPCPUTime_day1,AMPCPUTime_day2,SpoolUsage_1,
SpoolUsage_2,QueryText

prod_batch Insert 12 13 200 300 5000 6000 INSERT INTO production_db.employee
prod_batch Insert 12 13 200 300 5000 6000 INSERT INTO production_db.customer
prod_batch Insert 12 13 500 50 50000 60000 INSERT INTO production_db.sales

  • Database
  • SQL