1 Reply Latest reply: Oct 25, 2012 3:49 PM by Thomas Zloch RSS

Performance issue on konp and konv

santhosh kumar
Currently Being Moderated

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

  • Re: Performance issue on konp and konv
    Thomas Zloch
    Currently Being Moderated

    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

Actions