on 01-26-2011 8:58 AM
Dear SAP gurus,
We have a customized report which reads tables LIKP and LIPS. After we archived these two tables and reorg, the report takes execution time over 10 times as that before archiving (about 5,000 seconds before while 60,000 seconds after). but nothing changed to the report before or after archiving.
Our basis gave us some source code extraction as below which takes long execution time as below,
SELECT
/*+
FIRST_ROWS
*/
T_00 . "VBELN"
FROM
"LIKP" T_00 , "LIPS" T_01
WHERE
( T_01 . "MANDT" = :A0 AND T_01 . "VBELN" = T_00 . "VBELN" ) AND T_00 . "MANDT" = :A1 AND T_00 .
"ERDAT" BETWEEN :A2 AND :A3 AND T_01 . "MATNR" = :A4 AND ROWNUM <= :A5#
To modify the statement could improve some performance but anyway no source code change before or after archiving and reorg. I'm a functional consultant and from my perspective, data archiving and reorg should improve performance but do not know why this case is not applicable.
Thanks and best regards
>
> Dear SAP gurus,
>
> We have a customized report which reads tables LIKP and LIPS. After we archived these two tables and reorg, the report takes execution time over 10 times as that before archiving (about 5,000 seconds before while 60,000 seconds after). but nothing changed to the report before or after archiving.
>
> Our basis gave us some source code extraction as below which takes long execution time as below,
>
> SELECT
> /*+
> FIRST_ROWS
> */
> T_00 . "VBELN"
> FROM
> "LIKP" T_00 , "LIPS" T_01
> WHERE
> ( T_01 . "MANDT" = :A0 AND T_01 . "VBELN" = T_00 . "VBELN" ) AND T_00 . "MANDT" = :A1 AND T_00 .
> "ERDAT" BETWEEN :A2 AND :A3 AND T_01 . "MATNR" = :A4 AND ROWNUM <= :A5#
>
> To modify the statement could improve some performance but anyway no source code change before or after archiving and reorg. I'm a functional consultant and from my perspective, data archiving and reorg should improve performance but do not know why this case is not applicable.
>
> Thanks and best regards
Is possible that the archiving task, slows down the system performance?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.