Performance tuning..

[Former Member]

SELECT a_{matnr a}meins INTO CORRESPONDING FIELDS OF TABLE maratab

FROM mara AS a INNER JOIN marc AS b ON a_{matnr = b}matnr

WHERE b~werks = werks.

SELECT a_{matnr a}prueflos a~ebeln INTO TABLE it_lot

FROM qals AS a INNER JOIN qave AS b

ON a_{prueflos = b}prueflos

FOR ALL ENTRIES IN maratab

WHERE a_{matnr = maratab-matnr AND b}vaedatum IN ud_date

AND a_{stat35 = 'X' AND a}lmengezub = 0.

What all can be done apart from creating index to improve the performance tuning?

[Former Member]

SELECT a_{matnr a}meins INTO CORRESPONDING FIELDS OF TABLE maratab

FROM mara AS a INNER JOIN marc AS b ON a_{matnr = b}matnr

WHERE b~werks = werks.

sort maratab.

delete adjascent duplicates from maratab.

if maratab is not initial

SELECT a_{matnr a}prueflos a~ebeln INTO TABLE it_lot

FROM qals AS a INNER JOIN qave AS b

ON a_{prueflos = b}prueflos

FOR ALL ENTRIES IN maratab

WHERE a_{matnr = maratab-matnr AND b}vaedatum IN ud_date

AND a_{stat35 = 'X' AND a}lmengezub = 0.

endif.

In this way we can reduce the time for the second query.

Regards,

Nikhil

[Former Member]

Moderator message - Please see and [Asking Good Questions in the Forums to get Good Answers|/people/rob.burbank/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers] before posting again.- post locked Rob