5 Replies Latest reply: Apr 5, 2013 2:15 PM by uppu narayan RSS

Performance issue in KONV table

Ananya Mukherjee
Currently Being Moderated

Hi,

 

In our Z-program the below query is used to fetch data from KONV table -

"SELECT KNUMV KPOSN STUNR ZAEHK KAPPL KNUMH KWERT

INTO CORRESPONDING FIELDS OF TABLE IT_KONV

FROM KONV

FOR ALL ENTRIES IN IT_KONH

WHERE KAPPL EQ IT_KONH-KAPPL

AND KNUMH EQ IT_KONH-KNUMH."


Its taking a huge time to be executed. So in foreground, the program is showing 'TIME OUT' error for this query only.

 

As KONV table is a cluster table, we can't create any index on this table on the basis of the field (KAPPL, KNUMH).

Please suggest what will be process to increase performance of KONV table.

Actions