Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Dec 2003 @ 22:17:20 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Home grown performance reporting
From:   Harizanov, Ivan A


I spent some time not longer ago to understand the ResUsage tables and wrote some SQL which it seems to be ok.

This is the SQL

from   DBC.ResUsagesPma
where TheDate =  DATE
group  by 1,2
order by 1,2;

You should dedicate some time to understand the meaning of each column, the best place to look is the Teradata RDBMS Performance Optimization manual.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019