I had one issue regarding data fetching from MSKA " Sales Order Stock".
I have 52+ lac records in MSKA table.
On MSKA table two indexes.
1 - for VBELN, POSNR fields
2 - for MATNR, WERKS, LGORT, CHARG, SOBKZ fields
Mainly while fetching data from MSKA table with where vbeln and posnr parameter data fetch easily.
When fetch using matnr, werks, lgort, charg parameter it's took long time, sometime time out for material ranges.
please anyone have idea regarding indexing priority or any alternative of table please suggest.
It may be performance tuning issue then please forgive but please reply.