MB5B report is taking long time to display even single material for single date. what are the indexes should be on mkpf and mseg
the following query in mb5b is taking time.
SELECT (G_T_MSEG_FIELDS)
INTO CORRESPONDING FIELDS OF TABLE G_T_MSEG_LEAN
FROM MKPF AS MKPF JOIN MSEG AS MSEG
ON MKPF~MANDT = MSEG~MANDT AND
MKPF~MBLNR = MSEG~MBLNR AND
MKPF~MJAHR = MSEG~MJAHR
CONNECTION (DBCON)
WHERE MSEG~MATNR IN MATNR
AND MSEG~WERKS IN G_RA_WERKS
AND MSEG~LGORT IN G_RA_LGORT
AND MSEG~CHARG IN CHARG
AND MSEG~BWTAR IN BWTAR
AND MSEG~BWART IN BWART
AND MKPF~BUDAT GE DATUM-LOW
AND MSEG~SOBKZ IN G_RA_SOBKZ
%_HINTS DB2 '&SUBSTITUTE VALUES&'
ORACLE '&SUBSTITUTE VALUES&'.