Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Performance issue on konp and konv

Former Member

‎10-25-2012 10:54 AM

0 Kudos

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

1 REPLY 1

ThomasZloch
Active Contributor

‎10-25-2012 2:49 PM

0 Kudos

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