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.
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.