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
Showing results for 
Search instead for 
Did you mean: 

performance issue

Former Member
0 Kudos

My code below is taking too much time around 13,369,415

I need to improve the performance of the code. any ideas!!!

  SELECT SINGLE aufnr
        FROM mseg
        INTO v_aufnr
        WHERE charg IN charg
        AND   bwart = v_move.

3 REPLIES 3

rodrigo_paisante3
Active Contributor
0 Kudos

Hi.

The use of IN kill performance. Try to select without IN.

Regards.

Former Member
0 Kudos

I tried without

IN

and its the same performace. It has to do with

MSEG

table, I think the table has a lot of data and too many fields.

Former Member
0 Kudos

Use AUFM table