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 --
>
Received on Thu Sep 29 2005 - 22:28:11 CDT