April 2, 2004 at 5:02 am
Is there a way to find out procedure estimated execution time without executing the procedure ?
--sntiwary
April 2, 2004 at 7:47 am
should be showplan_all
April 2, 2004 at 7:47 am
Many factors effect estimated execution time, like cache hit rate, io speed, network throughput.
You do have EstimateCPU by turn on showplay_all.
April 3, 2004 at 1:54 am
Hi sntiwary,
Before executing your stored procedure, click ctrl + k, so that the execution plan will be set to on. Now you run the query, here you can find 3 tabs in the result pane ie., Grids, Execution Plan, Message.
By clicking on the Execution Plan tab window, you can find the step wise % of each transaction written in the stored procedure logic.
Lucky
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply