-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Program executing time (St05 results)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Program executing time (St05 results)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2008 Dec 08 12:56 PM
- SAP Managed Tags
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2008 Dec 08 1:43 PM
- SAP Managed Tags
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2008 Dec 08 1:43 PM
- SAP Managed Tags
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2008 Dec 08 7:40 PM
- SAP Managed Tags
- ABAP Testing and Analysis
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2008 Dec 08 7:47 PM
- SAP Managed Tags
- ABAP Testing and Analysis
It would help to see the original ABAP SELECTs rather than the output from the explain.
Rob
Bluesky