Re: Record row count and execution time into table?

Get the time before the query and get it after the query and diff the two values. The question is how accurate a value do you want. I say the minimum query time for your purposes should be one second so you can just use sysdate. Fractions of a second are meaningless since so many other factors such as user load at the time of the query and the need to get consistent read blocks will vary with every execution.

HTH -- Mark D Powell -- Received on Fri Sep 30 2005 - 10:29:08 CDT