Ansicht
Dokumentation
12407 - Tcode ME52 slow on V5R2
General Data in Customer Master PERFORM Short ReferenceThis documentation is copyright by SAP AG.
Tcode ME52 slow on V5R2
Hello everyone,After we upgraded our production system from V4R5 to V5R2 with lastest CumPack,
DB Fix, HIPER group, and other PTFs in II13337, we noticed that Tcode ME52 got
very slow, and verified that it is slow on our DEV/TST box also.
The SAP support folk found the slow SQL statement against table MARA and MARC,
and directed us to IBM support. The IBM support recommended a few PTFs. Some of
them were so "new" that they were not available for download yesterday.
I am curious how the other folks in this group execute Tcode ME52 on V5R2. The
SQL statemnt is
SELECT
T_00 . "MATNR" , T_01 . "WERKS" , T_01 . "XCHAR" , T_00 . "MTART" ,
T_00 . "MATKL" , T_00 . "MEINS" , T_01 . "TRAME" , T_01 . "UMLMC" ,
T_00 . "LVORM" "LVORM_MARA" , T_01 . "LVORM" "LVORM_MARC"
FROM
R3PRDDATA/"MARA"T_00 , R3PRDDATA/"MARC"T_01
WHERE
( T_01 . "MANDT" = ? AND T_00 . "MATNR" = T_01 . "MATNR" ) AND T_00 .
"MANDT" = ? AND T_00 . "MATNR" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
?....
, ? , ? ) AND T_01 . "WERKS" = ? WITH UR
And the library/SQL package/statement is R3PRDX0000/MARA/IHBHNKBKMOHKEMDO.
SQL4021 Access plan last saved on 12/15/03 at 06:19:58.
SQL4020 Estimated query run time is 11 seconds.
SQL4017 Host variables implemented as reusable ODP.
SQL4007 Query implementation for join position 1 table 2.
SQL4006 All indexes considered for table 2.
SQL4008 Index "MARC+WRK" used for table 2.
SQL4011 Index scan-key row positioning used on table 2.
SQL4007 Query implementation for join position 2 table 1.
SQL4006 All indexes considered for table 1.
SQL4009 Index created for table 1.
SQL4014 1 join column pair(s) are used for this join position.
SQL4015 From-column 1.*HOSTVAR, to-column 1.MATNR, join operator MF, join
predicate 1.
SQL4011 Index scan-key row positioning used on table 1.
Anybody has similar/different experiences with ME52 on V5R2?
Thank you very much,
Victor
SAP Basis Manager
Plastiapk Packaging INC
Durban Tours - Südafrika Safari
ROGBILLS - Synchronize billing plans CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 2584 Date: 20240418 Time: 082633 sap01-206 ( 3 ms )