cancel
Showing results for 
Search instead for 
Did you mean: 

Performance problem after data archiving and reorg

former_member674271
Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

>

> 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?

former_member674271
Contributor
0 Kudos

Dear spantaleoni,

We did reorg after the archiving tasks, so the tasks had already finished before the report performance got down. Anything needs to adjust we missed after reorg please?

Regards