Post reply

How to find out a procedure estimated execution time?

  • April 2, 2004 at 5:02 am

    #108025

    Is there a way to find out procedure estimated execution time without executing  the procedure ?

    --sntiwary

     

  • April 2, 2004 at 7:47 am

    #501613

    should be showplan_all

  • April 2, 2004 at 7:47 am

    #501612

    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

    #501694

    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