Archives of the TeradataForum
Message Posted: Fri, 10 May 2002 @ 15:47:49 GMT
| 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.