Subject | how to measure stored procedure performance |
---|---|
Author | Sean |
Post date | 2007-07-13T19:52:07Z |
Hi,
I have a stored procedure w/ multiple steps. In order to measure how
long each step takes, I output current_timestamp/current_time after
each step. But it seems the time doesn't change.
Is there a way to measure the time taken for each step?
Best,
Sean
I have a stored procedure w/ multiple steps. In order to measure how
long each step takes, I output current_timestamp/current_time after
each step. But it seems the time doesn't change.
Is there a way to measure the time taken for each step?
Best,
Sean