Performance issue on konp and konv
I am working on performance issues . I have fallowing select query ..
SELECT KNUMH KSCHL KBETR FROM KONP INTO TABLE I_KONP FOR ALL ENTRIES IN I_A902 WHERE KNUMH = I_A902-KNUMH
AND KSCHL = 'ZMRP'.
I created secondary index for KONP with knumh & kschl . But it is still taking lot of time in Production while fetching data.
will you please anybody suggest how to increase the performance of this statement.