Re: Record row count and execution time into table?

Thanks for the link.

My real question is what is the easiest way to find out how long it takes to count the rows in each table as well.

So, the output would look like this:

OWNER    TABLE_NAME        NUM_ROWS  SECONDS
-------- ----------------- --------  -------
OWNERX   ACS_APPL_SERIES1       314     0.02
OWNERX   ACS_APPL_SERIES2       314     1.21
OWNERX   ACS_GEN                  1     0.01



Mark D Powell wrote: 
Whoops, wrong link.  Try this one instead:

Is there a simple way to produce a report of all tables in the database
with current number of rows ?
http://www.jlcomp.demon.co.uk/faq/count_all_rows.html

HTH -- Mark D Powell --

.