Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

index use


I have a doubt about using index.

Selecting from MSEG table we are filtering by matnr, werks and mjahr fields when the primary key is mblnr, mjahr and zeile.

But looking for standard index we have index M with mandt, matnr, werks, lgort, bwart and sobkz fields.

I am wondering if using this index and selecting from MSEG using only matnr and werks fields (and later delete from internal table filtering with mjahr) we will improve the performance or u have to use all five fields of every index in order to improve the performances.

Thank you.

Not what you were looking for? View more on this topic or Ask a question