Skip to Content
0
Nov 27, 2009 at 07:45 AM

MB5B index

42 Views

Hi all,

Below select statement used in MB5B. It is very slow.

does anyone know indexes of below query.

SELECT (G_T_MSEG_FIELDS)

INTO CORRESPONDING FIELDS OF TABLE G_T_MSEG_LEAN

FROM MKPF AS MKPF JOIN MSEG AS MSEG

ON MKPFMANDT = MSEGMANDT AND

MKPFMBLNR = MSEGMBLNR AND

MKPFMJAHR = MSEGMJAHR

WHERE MSEG~MATNR IN MATNR

AND MSEG~WERKS IN G_RA_WERKS

AND MSEG~LGORT IN G_RA_LGORT

AND MSEG~CHARG IN C.HARG

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&'.

Thanks,

Vikas