Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 May 2002 @ 15:47:49 GMT


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


Subj:   Re: SQL to get table name with row counts?
 
From:   Mike Vanole

If you archive your databases you can always parse your arcmain output and get everything you want - rows AND bytes. It's not very sexy, but it works. After every archive we run, the output is parsed and loaded to a table (we don't use asf2). This gives us excellent trending, and metrics reporting abilities, including how long it takes to archive something. There are also built-in tables in the xasf_fast_path database that might have what you want, but we didn't use these because they seem unreliably updated.

You might also query dbc.tablesize and dbc.columns. Take the sum of your column lengths (rows) by table from dbc.columns and divide it into the bytes from tablesize. If you manage to get this it will only be approximate due to partially populated (or null) columns, but I would like to see the query.

Mike



     
  <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: 27 Dec 2016