Record row count and execution time into table?

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

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

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

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

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

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

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

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

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