Sql Trace

25 Views

Hi all,

I am trying to analyze the performance the of sql statement in se38 program. I placed the breakpoint at the select statement. then in another session I activated the trace in st05. After the select statementis executed I deactivated the trace and clicked on analyze trace. I can see list of statements but I do not understand how to find out the runtime of this statement and how expensive it is.

I know how to do it with se30 and tips and tricks. I just wan to know how to do with st05.

I am forwarding the code too.

REPORT ZSELECTDEMO.

tables sflight.

data : itab like sflight occurs 0 with header line.

select * from sflight .

itab-carrid = sflight-carrid.

itab-connid = sflight-connid.

itab-fldate = sflight-fldate.

append itab.

clear itab.

endselect.

loop at itab.

write :/ itab-carrid,itab-connid,itab-fldate.

endloop.

Please help with this.

Regards,

Varun.