Performance tunning

[Former Member]

Dear All,

I've few doubts regarding performance tunning

1. Suppose i'm using MSEG table where the primary key is MBLNR , MJAHR n ZFILE as the primary key

if in my where clause i use MBLNR and MJAHR would it take the primary index or full table scan be done.

2. SELECT * INTO TABLE lt_mseg

FROM mseg

FOR ALL ENTRIES IN it_....

WHERE mblnr EQ ...

AND mjahr EQ .....

AND bwart EQ '1011'.

instead of this i use

SELECT * INTO TABLE lt_mseg

FROM mseg

FOR ALL ENTRIES IN it_....

WHERE mblnr EQ ...

AND mjahr EQ .....

and then

delete from it_mseg where bwart eq = '1011'

which 1 would be faster.

3.

SELECT belnr gjahr ebeln bewtp bwart buzei dmbtr

INTO TABLE lt_ekbe

FROM ekbe

FOR ALL ENTRIES IN lt_....

WHERE ebeln = ......

and xblnr = .....

AND belnr = ......

AND gjahr =....

AND bewtp = 'D'.

or should i write

SELECT belnr gjahr ebeln bewtp bwart buzei dmbtr

INTO TABLE lt_ekbe

FROM ekbe

FOR ALL ENTRIES IN lt_....

WHERE ebeln = ......

AND gjahr =....

AND belnr = ......

AND bewtp = 'D'.

and xblnr = .....

in the second dtatment the fields are in sequence of the table, would there be any difference in the performance tunning

as in both cases the table is full scanned.

Regards

Sanjeev

[Former Member · Accepted solution]

Hi,

Please go through below link

http://www.wilsonmar.com/sap_perf.htm

Kapil