Skip to Content
0
Former Member
Oct 13, 2006 at 04:25 AM

performance issue => re-build MSEG Index

139 Views

Hi all,

The performance of all program is very low if the table

MSEG is involved in program.

For example, MB51.

I have checked that MSEG has built-in 3 default index.

then previous colleague made extra 5 index.

they are:

Name Fields

-


-


Y01 MANDT + AUFNR + BWART

Y02 MANDT + LGORT + AUFNR

Y03 MANDT + WERKS + LGORT + MATNR CHARG

Y04 MANDT + LGORT + CHARG

Z05 MATNR + WERKS + BWART + CHARG + AUFNR

Now the questions are:

1. is the MANDT field is necessary for index? if not, then does it affect the index effectiveness? for example , Y01 change to AUFNR + BWART will be better?

2. do i need to concern the sorting of field? eg. does it different for Y02 in MANDT + AUFNR + LGORT compared to orginial one.

3. Do i need to restart the server to take effect if i change the index?

4. does too many indexs created in MSEG will slow down the program performance? how many index no. is suitable in MSEG normally?

SOrry for many question.

Thanks in advance for any positive feedback.

I will reward the points for any good ideas.