Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Record row count and execution time into table?
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? Received on Thu Sep 29 2005 - 20:04:05 CDT
![]() |
![]() |