Record row count and execution time into table?

[Database Administrator]

I was wondering if anyone knows the best way to count the number of rows
in a table and enter this row count into a table along with how long the
query took to execute?

I realise that you can get both the row count and SQL execution time by
turning timing on and then running the select count(*) ... but then I
have to format the results and then do the insert into a table.

Is there an easier way?

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

Check out the following article which has a code sample to generate a
select count(*) and execute it

Is there a good way of counting the number of rows in a table ?
http://www.jlcomp.demon.co.uk/faq/count_rows.html


Adding time would be trival.

HTH -- Mark D Powell --

[Database Administrator]

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