topic Re: INDEXES in Application Development and Automation Discussions

INDEXES

Former Member — Wed, 12 Dec 2007 11:19:16 GMT

hi all,

i want to create the secondary index on mseg table.

here i am having select stament like this...

which fields can i select in the secondary index.

give me a brief explain.

SELECT MSEG~MBLNR

MSEG~BWART

MSEG~WERKS

MSEG~SHKZG

MSEG~MATNR

MSEG~ERFMG

MSEG~UMWRK

MKPF~MBLNR

MKPF~BUDAT

MSEG~XAUTO

MSEG~EBELN

INTO TABLE I_3MSEG

FROM MSEG

INNER JOIN MKPF

ON MSEG_{MBLNR = MKPF}MBLNR

WHERE MSEG~BWART IN ('301')

AND MSEG~MATNR IN S_MATNR

AND MSEG~WERKS IN S_SPLANT

AND MSEG~UMWRK IN S_RPLANT

AND MKPF~BUDAT IN S_AEDAT

AND MSEG~XAUTO <> 'X'

AND MSEG~EBELN IN S_EBELN.

Regards..

Anand.N

Re: INDEXES

Former Member — Wed, 12 Dec 2007 11:28:47 GMT

In below select statement, u r not using any key fields like MBLNR,

MJAHR ,ZEILE in condition. So it should give some performance problem. You can take BWART,XAUTO,MATNR,WERKS,LGORT fields in secondary index as the same order.

Reward if it dose.

Thanks

Siva Kumar

Re: INDEXES

Former Member — Wed, 12 Dec 2007 14:15:15 GMT

I wouldn't create a secondary index on a standard SAP table just to speed up one SELECT statement. There is overhead to the creation of indexes. Try to find a programming solution. Can you ensure that S_MATNR is not empty before the SELECT? What about S_EBELN?

Rob