Skip to Content
0

MSEG Table performance issue

Jul 14, 2017 at 06:05 PM

45

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers