how to find execution time for select statement in a report

[former_member573132]

Hi,

  i am using below selection statement in my report and i am trying see the execution time only for the select query in se30 how is it possible any one pls post the right solution.

select ebeln

          ebelp

          ardet

          netpr

          menge

          matnr from ekpo into table it_ekpo where ebeln = ekpo~ebeln.

regards

venkata subbareddy

[rajeshkothamasu]

Hi,

follow the below procedure

Step 1: Access transaction ST05. From the initial screen, click the check box for SQL trace, under the trace

requests, click Trace on.

Step 2: Run the program containing the SQL query that needs to be analyzed in the SE38 editor.

Step 3: Come back to ST05 screen, underTrace requests, click Trace off.

Step 4: Click List trace to view the trace of the current statement.

hope this will help you

[former_member573132]

hi rajesh

      your answer is good its finding execution exactly thanks for your answer rajesh.

[rajeshkothamasu]

Hi,

if you find an solution for the post. Close the discussion.

[former_member183607]

Hi,

     If you want only execution time then use t-code ST05 - Sql Trace.

[Former Member]

use st05.

Activate the trace.

Run your program.

deactivate the trace.

Then select display trace.

enter object name as ekpo. execute.

In the menu trace list ->summerize trace list by sql statements.

Here ull see a summerised list.

[former_member573132]

Hi,

your answer is good its finding execution exactly thanks for your answer rajesh

[former_member573132]

Hi,

   Its god thanks for ur answer.

Thanks 

venkata subbareddy

[former_member573132]

hi,

your answer is good its finding execution exactly thanks for your answer rajesh