Skip to Content
0
Dec 08, 2009 at 09:24 PM

Performance issue with transaction MC50

86 Views

I am not sure where to post this question. If I need to post it in another forum, please let me know.

We are having performance issues with transaction MC50. After reviewing SAP Note 457615 we created an index on mseg with the following fields: MANDT, MJAHR, MATNR, WERKS and SOBKZ.

When running an explain on the sql statement, the database is using a different index. This index has the following fields MANDT, MATNR, WERKS, LGORT, BWART and SOBKZ.

The sql statement is ( sql trace from ST05):

SELECT * from mseg WHERE "MANDT" = '400' AND "MJAHR" BETWEEN 2009 AND 2009 AND "MATNR" = '000000000054001121' AND "WERKS" = 'SAT' AND "SOBKZ" IN ( 'K' , 'V' , 'W' , 'O' , ' ' )

Is there any way to force the database to use the newly created index.

Thanks....Tommy

Edited by: Tommy Knight on Dec 8, 2009 2:24 PM

Edited by: Tommy Knight on Dec 8, 2009 3:07 PM

Edited by: Tommy Knight on Dec 8, 2009 3:08 PM