Skip to Content
avatar image
Former Member

MSEG Table performance issue

hi Team,

We have 640 GB size of MSEG table running on oracle 11g database.

But this is taking longer time in fetch and having slow performance.Below is the SQL query being used in program

SELECT mjahr mblnr zeile budat_mkpf vgart_mkpf
werks lgort kokrs kostl
matnr bwart grund menge
meins dmbtr waers "SAP-5367
APPENDING CORRESPONDING FIELDS OF TABLE t_docitems
FROM mseg
FOR ALL ENTRIES IN it_matnrpack
WHERE matnr = it_matnrpack-matnr
AND budat_mkpf EQ wa_budmat-budat
AND werks EQ p_werks
AND bwart IN s_bwart
AND lgort IN s_lgort
AND kostl IN s_kostl.

Index is being used in this query but having fileds MANDT,MATNR,WERKS,GRUND and LIFNR.

Please suggest if any improvements is there which can be improve performance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers