 |
 |
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.
Mike
| |
