10-25-2012 10:54 AM
Hi Guru's,
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.
Thanks,
Santhosh.V
10-25-2012 2:49 PM
I think this secondary index is useless, as KNUMH is already first field of the primary key.
Are you sure it is this statement causing the problems? Did you run a runtime analysis (SAT) to find out? How are you filling the I_A902 table before, are you including KAPPL EQ ... in the where-conditions?
Please run SAT and provide more surrounding code if still in doubt.
Thomas