Skip to Content
0
Jan 26, 2011 at 08:58 AM

Performance problem after data archiving and reorg

36 Views

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