Skip to Content
0
Former Member
May 19, 2005 at 08:24 AM

Index on table.

32 Views

Hi,

I have made a new index on MSEG table.

Z09 --> including MANDT + MATNR + WERKS + BWART

I can se in ST05 that it do not hit my index....

I have done some investigation and run this in SQL ANALYSER (SQL SERVER 2000) (modifying it a little bit...)

TEST nr 1 will give me another index.

TEST nr 2 gives me Z09. (Which is the right one.)

SAP sends nr 1 to SQL SERVER.

Any pointers ?

1 .SELECT "MBLNR" ,"MJAHR" ,"BWART" ,"MATNR" ,"WERKS" ,"LGORT" FROM u01.MSEG WHERE "MANDT" = '100' AND "MATNR" = '000000000000117721' AND "WERKS" = '3100' AND "BWART" = '101'

2. SELECT "MBLNR" ,"MJAHR" ,"BWART" ,"MATNR" ,"WERKS" ,"LGORT" FROM u01.MSEG WHERE "MANDT" = 100 AND "MATNR" = '000000000000117721' AND "WERKS" = '3100' AND "BWART" = '101'

//Martin