Program executing time (St05 results)

[Former Member]

Hi all,

I am working on an issue where a program is taking a huge time to execute...I tried to run the trace on using ST05 and found the following arears which are taking more time, so can you please suggest me what should I do with this to increase the efficiency of the program:

1. SELECT

"OBJECTID" "PONUMBER" , "USERNAME" , "UDATE" , "UTIME" , "CHANGENR" ,

"CHANGE_IND"

FROM

"CDHDR"

WHERE

"MANDANT" = ? AND "OBJECTCLAS" = ? AND "OBJECTID" IN ( ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?

, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) WITH

UR OPTLEVEL( 5 ) QUERY_DEGREE( 1 ) )

2.

SELECT

T_00 . "EBELN" "PONUMBER" , T_00 . "EBELP" "LINE_NO" , T_00 . "DMBTR" ,

T_00 . "CPUTM" , T_00 . "ERNAM" ,

FROM

"EKBE" T_00 , ( SELECT * FROM ( VALUES ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),

( CAST ( ? AS VARCHAR(30) ) ) ) AS T_01_TMP ( "C_01" ) GROUP BY "C_01" ) AS

T_01

WHERE

T_00 . "MANDT" = ? AND T_00 . "EBELN" = T_01 . C_01 AND T_00 . "DMBTR" <> ?

and

3.

SELECT

"MANDANT" , "OBJECTCLAS" , "OBJECTID" , "CHANGENR" , "PAGENO" , "TIMESTMP" ,

"PAGELG" , "VARDATA"

FROM

"CDCLS"

WHERE

"MANDANT" = ? AND "OBJECTCLAS" = ? AND "OBJECTID" = ? AND "CHANGENR" = ?

ORDER BY

"MANDANT" , "OBJECTCLAS" , "OBJECTID" , "CHANGENR" ,

Thanks,

Rajeev Gupta

[former_member194613]

please try, aggregation go to Table -> Summary of SQL Statement

Each of your statements should be visible as one line. What are the values for:

Table:

Duration:

Exec:

Rec:

Mintime/R:

Ident:

Which database are you using? Go the system -> status

[Former Member]

we are using DB6...but my concern is I haven't developed this program, so I was just wondering if the statements that I put in my post are written in the right way or do I need to do some performance analysis there???

Thanks,

Rajeev

[Former Member]

It would help to see the original ABAP SELECTs rather than the output from the explain.

Rob